Microsoft SQL Server

Tools:

Program	Version	Licence	Description
SQL Server Surveyor	1.0.3.2	Freeware	A tool which allows database administrators to easily create reports of their SQL Servers for the purposes of documentation, auditing, comparison with other servers, etc.

SQL Script	Description
Check Date Format	Compare date format of the SQL Server with a predefined date format.
Check Jobs	Check whether any scheduled jobs have failed and email the errors to the administrator(s).
Deleting records from large tables	How to delete a large number of records based upon a certain criteria without blowing out the transaction log.
Using ActiveX to Assign Global Variables in DTS Packages	How to use ActiveX Script Task to apply values stored in Global Variables to various objects in a DTS package.
FTP Scripts	Scripts to easily transfer one or more files between SQL Server and an FTP server.
Saving SQL Query Results to Comma Delimited Files (CSV)	Save query results to a file without the need to use DTS packages or BCP.
Logins Audit	Audit the level of access on SQL Server. It obtains members for database roles as well as server role members. It also creates three html reports which are then emailed.

Problem/Issue	Description
Microsoft SQL Server Management Studio is too Slow	Microsoft SQL Server Management Studio (SSMS) can take over 45 seconds to start. This tip will explain how to resolve this.
Running DTS Packages under SQL Server 2005	Find out how you can run SQL Server 2000 DTS Packages on SQL Server 2005