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

Azure SQL Managed Instance Versions

By

Just a really quick FYI for the readers. If you are using Managed Instances...

A summary of new features in Azure SQL Database

By

It has been some time since I last wrote about Azure SQL Database. Although...

Daily Coping 23 Jun 2021

By

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

Read the latest Blogs

Forums

Get total no of minutes by hour hand between two dates

By SSIS\SSRS\SSAS

am trying to avoid using while loop but OK with it... We are talking...

Get total no of minutes by hour hand between two dates

By SSIS\SSRS\SSAS

I am trying to avoid using while loop but OK with it... We are...

about the concern about sp_updatestats

By 892717952

Do I still need to run sp_updatestats  if I execute DBCC DBREINDEX(tablename) for tables...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers