Microsoft SQL Server


Tools:


Program

Version

Licence

Description

SQL Server Surveyor
1.0.3.2
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 Scripts:


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.

Tips:


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