SQL Server limits, done the way a record book does them. Not what the documentation says, but what happened when I tried one more. Eleven records, each attempted on SQL Server 2025 build 17.0.4085.5, each with the exact error text at the edge. One documented figure turned out to be wrong on this…
Reading the Transaction Log With fn_dblog
fn_dblog can expose transaction-log records during a narrow investigation, but retention and missing user context make it a last resort.
SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
No OS access? Run xp_fixeddrives from Management Studio to list each fixed hard drive with its free space, then plan where TempDB and indexes go.
SQL SERVER – List All the Tables for All Databases Using System Tables
A one line script with sp_msforeachdb and sys.tables to list all the tables for all databases on a server, updated with ideas from reader comments.
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Two more ways from Simon Worth to find table in every database of SQL Server, both built on sp_msforeachdb, one saving results to a temp table.
SQL SERVER – Stored Procedure to Know Database Access Permission to Current User
Which databases can I use? Run EXEC sp_MShasdbaccess to see the database access permission of the current user. Our Jr. DBAs check it all the time.
SQL SERVER – DBCC commands List – documented and undocumented
The full list of documented and undocumented DBCC commands with their syntax, plus how DBCC TRACEON(2520) and DBCC HELP show all of them in Query Analyzer.