I simply cannot believe all the issues I’m finding in SQL Server Management Studio (for other gripes see my
SQL Server 2005 category). The newest one is just plain dumb IMO (unless I’m doing something wrong). Recently I needed to implement a quick and dirty trigger for a test on one of my SQL Server 2005 databases, so I fired up SSMS expecting there to be a context menu option when you right click a table (ala Enterprise Manager) to create it. Nope, not there. Alright fine, do it via raw DML statements in a query window…easy enough. Execute the statement to create the trigger.
Now where the heck is it in object explorer? Programmability/Database Triggers? Not listed. Server Objects/Triggers? No way Jose, not there either. The only way to find it is select * from sysobjects where xtype = ‘TR’, and even then there’s no way to modify it without explicitly dropping it/recreating it via DDL. Perhaps my installation is mucked up somehow, but triggers are simply nowhere to be found in object explorer. This is getting ridiculous.
Share this post: 
|

|

|

|

|
