Tutorials about SQL Server
Use this repository to Reduce/Shrink Log File Database. It consist of 3 files :
- DBInfo.sql, used to get information of Log File Name.
- LogInfo.sql, used to get log data of a DB
- ShrinkLogFile.sql, used to shrink your DB
Use this repository to Activate Change Data Capture in your DB and Table
- CDC_Enable_DB.sql, used to enable CDC in DB. It is the First Query you should run.
- CDC_Enable_Tableo.sql, Second Query to run. Enable CDC in a Table.
- Status_CDC_DB.sql, used to get status CDC of Database.
- Status_CDC_Table.sql, used to get status CDC of Table.
- CDC_Disable_DB.sql, used to disable CDC in a DB.
- CDC_Disable_Table.sql, used to disable CDC in a Table.
- CDC_DB_Schema.sql, used to see Schema Information of DB, such as Capture Instance Name, Source Table Name.