Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Asynchronous trigger ?

Author  Topic 

manijash
Starting Member

8 Posts

Posted - 2009-05-19 : 11:43:29

Whatis Asynchronous trigger in sql server 2005 ?

Thanks in advance

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-05-19 : 12:03:57
It is something that doesn't exist, but you can use a trigger and service broker instead to mimic the functionality.

http://blog.delmonbay.com/2007/12/16/AsynchronousTrigger.aspx


Go to Top of Page

manijash
Starting Member

8 Posts

Posted - 2009-05-20 : 01:29:38
how to implement Asynchronous trigger ? Any documentation ?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-20 : 01:35:23
quote:
Originally posted by manijash

how to implement Asynchronous trigger ? Any documentation ?


Didn't you read the link that Rick posted ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

manijash
Starting Member

8 Posts

Posted - 2009-05-20 : 02:00:31
I need documentation and concept
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-20 : 02:07:00
tried googling ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-05-20 : 04:06:08
Please read the link I gave you, from there you can write your own documentation rather than ripping off someone elses as I guess you need this for a project (there is no other reason you'd be asking for it unless you had or expected contention issues on a project).

Otherwise, http://justfuckinggoogleit.com/
Go to Top of Page
   

- Advertisement -