Enables Change Data Capture (CDC) on all user databases
This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.
2025-08-25
10 reads
This script loops through all user databases, skips system DBs and any you want to exclude, and enables CDC if it’s not already enabled.
2025-08-25
10 reads
To fetch an execution plan from SQL Server's buffer cache (i.e., the in-memory cache of execution plans), you can query the dynamic management views (DMVs) that SQL Server exposes.
2025-04-30
116 reads
Explanation: sys.databases contains information about all databases on the SQL Server instance. • HAS_DBACCESS(name) = 1 filters out the databases you dont have access to. •ORDER BY name sorts the result alphabetically.
2025-03-04
265 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Hi everyone, I’m fairly new to working with SSIS in SQL Server 2005, and...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers