# Create User and permissions # ✅ SQL Server Debezium Test — Without `GO` ### **1. Create Database**
`CREATE DATABASE DebeziumTest;`
### **Switch Database**
`USE DebeziumTest;`
--- # ✅ 2. Enable CDC on the Database (Works without GO)
`EXEC sys.sp_cdc_enable_db;`
--- # ✅ 3. Create Test Table
`CREATE TABLE dbo.Customers ( CustomerID INT IDENTITY(1,1) PRIMARY KEY, FirstName NVARCHAR(100), LastName NVARCHAR(100), Email NVARCHAR(255), CreatedAt DATETIME DEFAULT GETDATE());`
--- # ✅ 4. Enable CDC on the Table
`EXEC sys.sp_cdc_enable_table @source_schema = 'dbo', @source_name = 'Customers', @role_name = NULL, @supports_net_changes = 0;`
--- # ✅ 5. Insert Sample Data
`INSERT INTO dbo.Customers (FirstName, LastName, Email)VALUES ('Golam', 'Kibria', 'golam@example.com'), ('John', 'Doe', 'john.doe@example.com'), ('Jane', 'Smith', 'jane.smith@example.com');`
--- # ✅ 6. Update Data
`UPDATE dbo.CustomersSET Email = 'golam.kibria@updated.com'WHERE CustomerID = 1;`
--- # ✅ 7. Delete Data
`DELETE FROM dbo.CustomersWHERE CustomerID = 2;`
--- # 🔍 8. Check CDC Status
`SELECT name, is_cdc_enabled FROM sys.databases WHERE name='DebeziumTest';`
`SELECT name, is_tracked_by_cdc FROM sys.tables WHERE name='Customers';`