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 |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2005-03-19 : 09:49:31
|
| hello can you tell me where actually triggers are stored in database. it is so nice of you. and also tell how i can receivce message returned with trigger in an application writtenn in VB. i am waiting for you people. help meamit kumar madhukar |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-19 : 10:26:34
|
triggers are stored in folder triggers.i guess you can use raiserror... what kind of message would you like to return?Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-20 : 02:53:29
|
| Trigger source is in syscomments - is that what you are after?EXEC sp_HelpText 'MyTriggerName'will give you the source code (if not encrypted)Kristen |
|
|
|
|
|
|
Where Triggers are stored