Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,627 reads
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,627 reads
A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.
2011-09-22 (first published: 2007-08-03)
1,707 reads
2007-12-27 (first published: 2007-10-23)
1,005 reads
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,198 reads
this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation
2007-11-06 (first published: 2007-07-27)
2,340 reads
this is a quick stored procedure I put together when trying to find a log for a particular day (xp_enumerrorlogs returns the archive is as a varchar, so 1 is followed by 11, 12 etc rather than 2) sp_display_errorlogs with no parms returns output in archive id order. if the parm 'size' is passed in, […]
2007-09-21
793 reads
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...
One of the new features in Kubernetes v1.33 is the ability to resize CPU...
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
When comparing AWS RDS and DynamoDB, the core difference lies in structure and use...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Comments posted to this topic are about the item Creating a new API in...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers