USER PROCESS CHECK (COMPLETE)

The following runable script is a very simple way to track SPID's and PROCESS information (VERY BASIC) in a small target (Local) database.1. Creates a small database 1.1 must set MDF and LDF (File location information) specific to the drive and file folder locations for each server2. Sets All db options3. Creates single table to […]

2005-01-14 (first published: )

204 reads

MSP_Restore

Simple Procedure to rapidly rebuild a copy of Development TEST1 DB...Lovely and fast when Tard Developers have highlevels of access  and you just need them out to restore / refresh a db...KILL KILL KILL !!! Remember to reset / resolve users and permissions after this is run. I use a DTS RUN statment with a […]

2003-12-18

170 reads

Blogs

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

By

When studying Azure one of the things you’ll be asked to learn is the...

Running SQL Server containers as non-root

By

Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

By Solomon Rutzky

Comments posted to this topic are about the item Stairway to SQLCLR Level 2:...

Database in Recovery Pending state

By bobba

Good Morning, We had an issue yesterday where SQL Alerts were generated from one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers