2014-11-17
2,039 reads
2014-11-17
2,039 reads
2014-07-01
1,921 reads
2014-03-25
2,189 reads
2014-01-24
2,457 reads
2013-04-10
2,151 reads
2012-12-19
2,241 reads
Generate a script of insert statements with column names for any table including those with identity columns.
2012-06-15 (first published: 2012-05-22)
3,130 reads
2011-08-26
2,773 reads
When you enter a new record into a table that contains an identity column, the identity value will be set with the next available value. Your database design often requires you to obtain that value, so you need to be able to find it.
2011-05-05
5,354 reads
2010-10-06
3,262 reads
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...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers