SQL Server 2005: How to Disable a Trigger June 20th, 2009
A trigger allows for the execution of SQL code anytime an UPDATE, INSERT, or DELETE command is performed on a certain table. If you are having to perform manual modifications to the table, you may not want the trigger to fire off. Here’s how to disable the trigger so that you can perform your administrative tasks:
To disable the trigger, open a query window and use the following command (inserting the proper Table Name and Trigger Name into the statement):
ALTER TABLE
SQL Server 2005: What Service Pack is Installed? June 20th, 2009
If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:
1. Open SQL Server Management Studio.
2. Click the New Query button.
3. Copy and paste the following into your query window:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
4. Click the Execute button.
The results will display the version number, service pack number and the edition of SQL Server 2005 that is installed on the server.
courtesy http://www.tech-recipes.com/rx/2729/sql_server_2005_what_service_pack_is_installed_/
