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
185 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
296 reads
Blogs
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Deceptive Visualizations
Comments posted to this topic are about the item Deceptive Visualizations
Argument syntax for SSIS Execute Process Task Editor
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
Seeking input on Best Method to Join on First or Last Row in a 1:M Join
I have included the DDL to re-create the 2 tables in this examples. I...
Ask SSC