View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,549 reads
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,549 reads
Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.
2010-05-14 (first published: 2009-06-24)
1,786 reads
2010-05-13 (first published: 2009-07-01)
3,915 reads
2010-05-12 (first published: 2009-07-09)
2,986 reads
When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.
2010-05-11 (first published: 2009-07-11)
3,169 reads
The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.
2010-05-10 (first published: 2009-07-16)
7,983 reads
2010-05-07 (first published: 2009-07-31)
3,372 reads
Given a tablename and other parameters, this procedure will return a table made of foreign keys and a checksum for each
2010-05-06 (first published: 2010-05-02)
2,046 reads
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
2010-05-05 (first published: 2010-04-28)
1,503 reads
2010-05-03 (first published: 2010-04-23)
2,019 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers