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
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
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
By Steve Jones
I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple...
You can find my slidedeck for the session “Introduction to Azure Data Factory” on...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi, Whenever I get an high cpu alert , be it non-working hours or...
I am using .LDF file to get the information about when was DB last...