build_restore_script

This script originally created by Greg Larsen has been modified by me. This procedure is used to create the restore commands needed to restore a database using the lates full and any transaction or differential backups. The parameter @dbname was added to just create the restore statements for a particular database. Leaving off this parameter […]

4.8 (5)

2005-06-07 (first published: )

1,212 reads

dropUnusedLogins

For those site using SQL Server ids as opposed to Integrated security there may be instances where occasionally SQL Server logins might get 'orphaned'. That is the login is not a member of any server group that has general database access nor does that login have specific access to any particular database.  Compile this proc […]

2004-03-01

270 reads

Blogs

Azure SQL Database – Error Logs?

By

Ok, so Azure SQL doesn’t really have its own error log based somewhere on...

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

For loop in C# script component

By rohitkocharda

Hi Everyone,I have a script task calling a sequence container. What i would like...

More Time to Certify

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Time to Certify

Difference Between Lists

By BTylerWhite

Comments posted to this topic are about the item Difference Between Lists

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers