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

Ignoring Comments in SQL Compare

By

Recently I had a client that wanted to know how they could use SQL...

PASS SQLSaturday’s I will be speaking at

By

I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that...

T-SQL Tuesday Retrospective #006: What about blob?

By

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project....

Read the latest Blogs

Forums

How to mantain index in SQL and size of Database

By andre1992

Hi everyone, I'm trying to figure out how to manage the maintenance of the...

vbs failing

By Sailor

This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile =...

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers