A simple script on sys.objects that shows the stored procedure create date and modified date, handy for audits and for watching changes to your objects.
SQL SERVER – 2005 – List All The Column With Specific Data Types
A handy script to list all columns with specific data types in a database. We used it to find TEXT columns and change them to VARCHAR(MAX) in SQL Server 2005.
SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
SQL SERVER – 2005 – List Tables in Database Without Primary Key
A simple script to list tables in database without primary key, using sys.tables and OBJECTPROPERTY TableHasPrimaryKey in SQL Server 2005.
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
SQL SERVER – Stop SQL Server Immediately Using T-SQL
Need to stop SQL Server immediately? Run SHUTDOWN, or SHUTDOWN WITH NOWAIT to skip checkpoints. I also note which roles have permission to run it.
SQL SERVER – One Thing All DBA Must Know
The one thing all DBA must know is to backup database fully. I also answer reader questions on the best time for a backup and how often to take one.