Technical Article

Check Full Recovery DBs Have Tran Log Backups

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.

3.71 (7)

You rated this post out of 5. Change rating

2011-09-22 (first published: )

1,703 reads

Technical Article

sp_displaylogin - sybase style

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 @

You rated this post out of 5. Change rating

2007-11-09 (first published: )

1,126 reads

Technical Article

Collation Checker

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

4.71 (7)

You rated this post out of 5. Change rating

2007-11-06 (first published: )

2,130 reads

Technical Article

proc to order xp_enumerrorlog

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, […]

You rated this post out of 5. Change rating


614 reads


Microsoft Announcement: Microsoft Fabric


Yesterday at Microsoft Build, a significant announcement took place—the introduction of Microsoft Fabric, which...

Introduction to SQL Server Query Store


Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...

Flyway with Multiple Folders


A customer asked about how they could organize their migration scripts in different ways...

Read the latest Blogs


Access db

By sqlguru

Access db wanting to move  sql server, how much control does business have over...


By sqlguru

I was thinking to add SSIS db to Always on AG group. So during...

Iterate Through Tables, Using a Control Table w/ a List of Tables to Process?

By Rich Mechaber

I'm trying to create an SSIS package that will query a master control table...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers