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.
Where has this been moved in SQL 2005.
-
-
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
Comment