Change Tracking

Question

Post reply

Change Tracking

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Miles Neale SSChampion Points: 13147 More actions · Answer 1

Miles Neale

SSChampion

Points: 13147

July 10, 2013 at 2:38 pm

#1631414

Sweet!

+1

Not all gray hairs are Dinosaurs!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 2

Had to guess. Reasoned that change tracking would require a PK. How else would you know what was changed? Thanks for the question.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Good question...

learn something new today 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 4

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Nice question. The idea that one can track changes to a table without some way of identifying a row which is changed is quite bizarre, particularly since SQL tables can contain duplicates, so it seems natural to require a primary key. For that reason I find it hard to understand why I got two points for answering this, instead of just one, but as points don't matter anyway I don't actually care.

Tom

sqlnaive SSCoach Points: 17437 More actions · Answer 6

sqlnaive

SSCoach

Points: 17437

July 22, 2013 at 3:53 am

#1634380

Good question. 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

tbs.jignesh SSC Veteran Points: 212 More actions · Answer 8

I don't have "ChangeTrackingDemo" database on my server, so it will give error for both the statements.

Please mention the considerations properly.