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 2000 Forums
 SQL Server Development (2000)
 Where is the trigger stored?

Author  Topic 

rushdib
Yak Posting Veteran

93 Posts

Posted - 2003-09-29 : 15:20:47
Hi,
From the Enterprise Manager, where do I find the triggers? I created the trigeer from the query analyzer and I did not see the trigger in the stored procedures collection.

Thanks,

Rushdi

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-29 : 15:24:47
A trigger is created for a table...go in to design view for the table and click on the icon immediatley top the right of the "key"



Brett

8-)

SELECT @@POST FROM Brain ORDER BY NewId()

That's correct! It's an AlphaNumeric!
Go to Top of Page

bripal
Starting Member

1 Post

Posted - 2003-09-29 : 15:38:59
Another way is to right click on the table, select All Tasks then select Manage Triggers.
Go to Top of Page
   

- Advertisement -