This script is a quick one to check some common server problems that may end up being annoying
The script checks the following :-
-- owners that don't exist any longer
-- databases on old compatibility levels
-- databases that haven't been backed up in the last week
-- full recovery databases with no transaction log backups in last 7 days
-- databases with different collations from server
-- databases with different collations of columns within
-- databases with column collations different from database collation
this procedure has been tested on sql server 2000 sp4 and SQL Server 2005 sp2
any problems email pgr_consulting @ yahoo.com
run as follows :-
exec sp_common_server_problems
go
