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 |
|
jagmeet2003
Starting Member
2 Posts |
 Posted - 2008-07-18 : 06:49:40
|
| Hi,I was trying to get information about the type of trigger but was not able to.I triedselect * from dbo.sysobjects where xtype='TR'this trigger gives me the names of triggers, but how can i find the type of trigger such as (befor, after, instead of etc.)Thanx in anticipation. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-18 : 09:18:35
|
| sp_helptext 'trigger_name'MadhivananFailing to plan is Planning to fail |
 |
|
|
jagmeet2003
Starting Member
2 Posts |
Posted - 2008-07-18 : 09:55:08
|
| Thanx for ur reply..actually this will return the script for the trigger.But my requirement is to fire a select query which returns the the result as the name and type of the trigger.Thanx in anticipation |
|
|
|
cvipin
Yak Posting Veteran
51 Posts |
Posted - 2008-07-18 : 10:00:35
|
| Select the trigger name and just hit Alt+F1.Not sure this is what u want.. |
|
|
|
|
|
|
get trigger information