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: )

207 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

172 reads

Blogs

Daily Coping 23 Sept 2021

By

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

Getting Up and Running with Dapr

By

I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...

Data Platform products for Microsoft gaps

By

Microsoft has a ton of data platform-related products, but there are certain areas where...

Read the latest Blogs

Forums

The OPENJSON return schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The OPENJSON return schema

Thank a Mentor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thank a Mentor

Create an RPA Flow that Connects to Oracle Data in UiPath Studio

By JerodJ

Comments posted to this topic are about the item Create an RPA Flow that...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers