Triggers drive me NUTS! 
Author Message
 Triggers drive me NUTS!
Anyone, please help!

Is there any way to get a trigger to launch a web page
when a table is finished updating???

I'm new to triggers and there's very little documentation
out there that I can find, if anyone knows a good book....

Help!



Fri, 29 Jul 2005 23:34:15 GMT
 Triggers drive me NUTS!

Triggers can launch processes inside SQL server like update another table,
etc.
You cannot control processes outside SQL server like launching a web page.


Quote:
> Anyone, please help!

> Is there any way to get a trigger to launch a web page
> when a table is finished updating???

> I'm new to triggers and there's very little documentation
> out there that I can find, if anyone knows a good book....

> Help!



Fri, 29 Jul 2005 23:54:56 GMT
 Triggers drive me NUTS!
Desperate:

You might try using the extended stored procedure xp_cmdshell
using a command line like:

start iexplore.exe www.microsoft.com


Quote:
> Anyone, please help!

> Is there any way to get a trigger to launch a web page
> when a table is finished updating???

> I'm new to triggers and there's very little documentation
> out there that I can find, if anyone knows a good book....

> Help!



Sat, 30 Jul 2005 00:05:23 GMT
 Triggers drive me NUTS!
hmmmm....

What about master..xp_cmdshell ?

Quote:
>-----Original Message-----
>Triggers can launch processes inside SQL server like

update another table,
Quote:
>etc.
>You cannot control processes outside SQL server like

launching a web page.
Quote:


message

>> Anyone, please help!

>> Is there any way to get a trigger to launch a web page
>> when a table is finished updating???

>> I'm new to triggers and there's very little
documentation
>> out there that I can find, if anyone knows a good
book....

>> Help!

>.



Sat, 30 Jul 2005 00:09:24 GMT
 Triggers drive me NUTS!
Why aren't you driving this from your app? When you finish the update
process, load your web page. If the table is being updated by Query Analyzer
directly by the dba, why would you have a web page load?

Michael MacGregor
Database Architect
SalesDriver



Sat, 30 Jul 2005 02:30:28 GMT
 Triggers drive me NUTS!
Well, supposedly it is a three tier architecture and the web server is on a
different machine. For security reasons you would not want to use
master..xp_cmdshell. I would not!


Quote:
> hmmmm....

> What about master..xp_cmdshell ?

> >-----Original Message-----
> >Triggers can launch processes inside SQL server like
> update another table,
> >etc.
> >You cannot control processes outside SQL server like
> launching a web page.


> message

> >> Anyone, please help!

> >> Is there any way to get a trigger to launch a web page
> >> when a table is finished updating???

> >> I'm new to triggers and there's very little
> documentation
> >> out there that I can find, if anyone knows a good
> book....

> >> Help!

> >.



Sat, 30 Jul 2005 03:18:05 GMT
 Triggers drive me NUTS!
Barney,

I'm not real sure that I understand what you mean by "launch a web page",
but as a guess, you might take a look at the sp_makewebtask system stored
procedure, and see if that fits your needs. Documentation on the
sp_makewebtask system stored procedure can be found in the SQL Server Books
Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> Anyone, please help!

> Is there any way to get a trigger to launch a web page
> when a table is finished updating???

> I'm new to triggers and there's very little documentation
> out there that I can find, if anyone knows a good book....

> Help!



Sat, 30 Jul 2005 03:25:06 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. DTS from ASP security driving me nuts!

2. Driving me nuts!!

3. SQL Error 2417 driving me nuts

4. I'm sure it something simple but it's driving me nuts :-(

5. Synax problem driving me nuts

6. HELP: isql is driving me nuts!

7. Index Tuning Wizard Driving me NUTS

8. Please Help, this is driving me nuts !!

9. SUB QUERY driving me NUTS!

10. This query is driving me nuts - please help !!

11. Stored Procedure Problem --- Driving me nuts!

12. HTTP 404 - File not found Driving me NUTS!!!!


 
Powered by phpBB® Forum Software