For those of us useing the SQL Server Health and History Tool (a.k.a. SQLH2) version 2.026 was released on 19 May 2005. A free download from Microsoft, the SQL Server Health and History Tool (SQLH2) collects information about your SQL Server installations. Details about which services/features are installed; configuration of the machine, OS and SQL […]
You are browsing archives for
Month: May 2005
DDL Trigger – Prevent and Notify DDL Changes
SQL Server 2005 allows you to create DDL Triggers in a database, that fire whenever someone attempts to change the structure of your database. Ever accidentally created tables / views / sprocs in the master database? Well Greg Low published a trigger you can place in the master database to prevent changes there. Apparently Greg’s […]
Setting your default database to tempdb
Personally I like to set the default database for all logins to tempdb. It helps people remember to select the correct database before they start doing things. If someone forgets to change their database, i’d rather them attempting to do crazy things in tempdb instead of master. There are some programs / install scripts that […]
Go home early with WAITFOR
It’s late at night, you’re still at work, waiting for long running task to complete so you can go home. Well why not make SQL Server 2005 wait for you? Well gather your things and make use of the new WAITFOR statement, thats been introduced as part of Service Broker. You can ask SQL Server […]