While working on a project sometimes it happened that we need to shift the database from one server to another due to various reason (sometimes it is only money ). We are aware that this easy step take backup and restore another machine but glitch is what about the users which have access to the …
I am pretty much sure by the title of this post you had idea of the post content. Although I am late to post this feature but anyways Change Tracking (CT) is a feature came in SQL SERVER 2008. As the name mention it track the changes like DELETE, INSERT , UPDATE type DML …