These topics all relate to SQL in one way or another - the majority of them are quite likely to be useful snippets
of SQL that assist with automating a single task, they may not be multi-functional but what they do offer is the
ability to do their single assigned task really well.
Although though we have tried our best make the quick links give you the most relevant items on this specific topic
however if what you want is not here you might want to try going back to the
main resources page
and having a look at some of the other topics on offer as you will find they cover a wide range of material.
T-SQL script for MS SQL Server, capable of performing a simple audit of password security across all logins (apart from NT authenticated logins) on the SQL Server and then presents the information discovered in a very simple report.
T-SQL script for MS SQL Server, displays information about the current service pack and server version. Allows automation of a tedious process - the script is already coded to knows which version strings match up to which service pack releases for versions 6.0, 6.5, 7.0 and 2000 of MS SQL Server.
T-SQL script for MS SQL Server, allows transation logs / logfiles to be shrunk whilst still keeping the database they are attached to on-line, meaning you can increase the amount of space available for use while not reducing availability of the database.