Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
5,399 reads
An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft
2010-05-21 (first published: 2009-05-07)
2,259 reads
Modified version of a script that can be found at http://www.sqlservercentral.com/Contributions/InstallEditor
2010-05-20 (first published: 2009-05-07)
3,957 reads
This script will generate a format friendly ddl statement for a predefined table in sql server.
2010-05-19 (first published: 2009-06-03)
1,971 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,522 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,757 reads
2010-05-13 (first published: 2009-07-01)
3,868 reads
2010-05-12 (first published: 2009-07-09)
2,953 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,144 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,955 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers