469,647 Members | 1,800 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

Triggers in SQL 2005

I wrote some triggers in SQL 2000, and could update etc them through the User interface in the design screen.

Where has this been moved in SQL 2005.
Jul 17 '07 #1
1 932
404 Expert 256MB
Hi WayneW,

If you go into MS SQL Server Management Studio,
expand the server,
expand the databases,
expand the database for which the triggers apply,
expand the tables,
expand the table of interest,

you will find folders for columns, keys, contraints, triggers, indexes and statistics. If you expand the trigger folder you should see those existing on the table, a right click will allow you to create new ones..

I am sure microsoft could have hidden the better, but I can't think where at the mo ;)

Regards Purple
Jul 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Mark Flippin | last post: by
5 posts views Thread by Praveen_db2 | last post: by
4 posts views Thread by JoeyD | last post: by
2 posts views Thread by kwilla | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.