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.
| Author |
Topic |
|
db_sysadmin
Starting Member
27 Posts |
 Posted - 2007-12-13 : 11:42:51
|
| Hey guys!, is there a way to raise an exception through an insert trigger... and that exception will be able to raise on every single application connected to that database at the time? not just the app that actually triggered the insert...Thanks in advance! |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2008-01-30 : 23:36:41
|
| There is noway to do what your are looking atworkaround is you can set some flag in some table and every connection (application) should check that flag before running any transactions and raise an error at the client side.Be specific on what you are trying to implement, may be forum can help you with better ideas.TechnologyYogihttp://gvphubli.blogspot.com/ |
 |
|
|
|
|
|
Insert Trigger - RaiseException to all clients