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 |
|
macca
Posting Yak Master
146 Posts |
 Posted - 2006-02-20 : 07:31:09
|
| I am creating a trigger in sqlserver 2000. I created it using the sql query analyzer.I went into the database and wanted to open the Trigger but cannot find it. Does anyone know where the trigger is saved to when it has been created and can I view it.Thanks,macca |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-20 : 07:35:38
|
Method 1 :- in Query Analyser, press F8 to show the Query Browser if it is not already shown- navigate to your database, table, triggers- right click on the trigger and select editorMethod 2 :sp_helptext trigger_name ----------------------------------'KH'Time is always against us |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-20 : 07:38:12
|
Method 3:  Enterprise ManagerOpen DatabaseRight click TableAll tasks : Manager triggersChoose the trigger from the drop-down listKristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-20 : 08:00:19
|
| Method 4select c.text from syscomments C inner join sysobjects oon c.id=o.id where o.xtype='tr'MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Creating triggers in sqlserver 2000