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
184 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
295 reads
Blogs
Goal Progress–November 2020
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
Azure Synapse Analytics is GA!
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
5 Things You Should Know About Azure SQL
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
Forums
Get data from last line and merge into data stream before removing
This script reads thru a file and removes the last line, but before it...
Firewall access for Availability Group listeners
Hello experts, I have a noob question as I never feel like I understand...
conversion of excel formula to case statement in tsql
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC