usp_createsnapshot
Stored procedure which creates snapshot of database. Timestamp in snapshot. Multiple datafiles are supported
2008-07-04 (first published: 2008-05-28)
838 reads
Scripts
usp_ActiveProcesses - SQL 2k5
Returns list of active processes and their buffer contents over a specified time.
2008-07-02 (first published: 2008-05-20)
1,476 reads
2008-06-30 (first published: 2008-05-20)
3,057 reads
sp_utilityFindObjectModifying
SHOW WHICH TABLES ARE MODIFIED BY A STORED OR FUNCTION OR WHICH STORED OR FUNCTION MODIFIES A TABLE
2008-06-27 (first published: 2008-05-21)
814 reads
2008-06-26 (first published: 2008-05-20)
924 reads
2008-06-25 (first published: 2008-05-20)
1,271 reads
2008-06-25
324 reads
2008-06-24 (first published: 2008-05-20)
2,223 reads
Check DTS Package Logs for Errors
This will let you know which package had errors rather than sifting through all the package logs one by one.You just need to replace the date.
2008-06-23 (first published: 2008-05-20)
719 reads
2008-06-20 (first published: 2008-05-11)
1,472 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers