SMS Script

This script will modify INI file on destops through SMS push to point server connection from A to B.

Distributing SQL Server Databases

Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.

Check owners, collations and backups

A script to check the owners, collations and backups on the server.

2005 unused indexes

Shows unused indexes compared to nr of modifications

You need to perform a restore operation as...

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.

Deadlock Notifications in SQL Server 2005

Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.

Max Actual datalength

This script returns the defined rowlength and the actual datalength for the longest row in a table.

Show Table, Index and Image/Text size.

This is a simple script that show size from a table and yours related objects.

Which security modes are supported by Service Broker?