Francis


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,216 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

271 reads

Blogs

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs

Forums

Simple Way to Recover Permanently Deleted AT&T Emails?

By emailspedia

If you are not from a technical background and you want to recover permanently...

shared datasets and cache refresh option

By ricky969

hi guys! Problem:  1) Every time I overwrite an existing shared dataset (with a...

Question on report server database

By itmasterw 60042

Hi,   We just installed SQL Server 2019 on a new server and moved...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers