sp_whoindb
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
186 reads
Load Backup History from Backup File
This script creates a stored proc to verify all backups in a media set and load their history into MSDB. I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine.
2003-03-11
297 reads
Blogs
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Running SQL Server in Windows Subsystem for Linux (WSL)
I previously wrote a post on how to convert a SQL Server Docker image...
Forums
The Migration Tool to Use III
Comments posted to this topic are about the item The Migration Tool to Use...
SSIS File System Deployments
I created a package that utilizes environment variables in the configuration manager to toggle...
Create a DACPAC to only update not replace a SQL Server Database
Hi there We have been creating a DACPAC from a SQL server database project...
Ask SSC