There is a new great WIKI ressource for common T-SQL solutions at MSDN Code Gallery, it's called SQLExampels. In this WIKI presented information, represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers (you know Arnie Roland… more »

By using SP_MSForEachDB you can detect and display orphan SQL-Server accounts from all the databases of your SQL-Server. EXEC SP_MSForEachDB 'USE [?]; -- SYSTEM DATABASE ARE EXCLUDED IF DB_ID(''?'') > 4 SELECT ''?'' as DBName, name… more »

Let us face it, when did you last change the sa password? You can check last change in SQL Server 2005, for the sa login by using LOGINPROPERTY function. Execute the following T-SQL code: SELECT LOGINPROPERTY ('sa', 'PasswordLastSetTime') And a little… more »