Change Tracking

Question

Post reply

Change Tracking

Error Handler

Ten Centuries

Points: 1086
More actions
July 9, 2013 at 9:27 pm

#279656

Comments posted to this topic are about the item Change Tracking
Best,
Naseer Ahmad
SQL Server DBA
July 10, 2013 at 3:37 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 22 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

Revenant

SSC-Forever

Points: 42467

July 9, 2013 at 10:41 pm

#1631061

Thanks for a simple one, Naseer!

sharath.chalamgari SSCertifiable Points: 5680 More actions · Answer 2

Good Question , even if we have the primary key and want to drop it, we need to disable the change tracking before we drop the constraint.

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Good question and straightforward explanation 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

Easy question for the day. Not sure..was it worth "2 points"? 😀

Anyways..thanks for the question Naseer.

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 5

Christian Buettner-167247

SSChampion

Points: 13729

July 10, 2013 at 12:42 am

#1631080

Thanks for the question

Best Regards,

Chris Büttner

paul s-306273 SSChampion Points: 10730 More actions · Answer 6

paul s-306273

SSChampion

Points: 10730

July 10, 2013 at 1:43 am

#1631101

Thanks for the question.

DivyaMohankumar SSC Rookie Points: 45 More actions · Answer 7

Hi

Can anyone explain Change tracking and its use...

Actually the answer given is correct it is Ans:"b" It's mistakenly hit Ans:"c"

I could appreciate if anyone answer this question clearly.

Divya Mohankumar

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 8

DivyaMohankumar (7/10/2013)
Hi
Can anyone explain Change tracking and its use...

Start here: http://msdn.microsoft.com/en-us/library/bb933875.aspx. Then, if you have any specific questions, let us know what those questions are.

Actually the answer given is correct it is Ans:"b" It's mistakenly hit Ans:"c"
I could appreciate if anyone answer this question clearly.

I'm not sure I understand this. Answer b is the correct answer to the question. If you think c should be correct, please explain.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

DivyaMohankumar SSC Rookie Points: 45 More actions · Answer 9

Yes as you say Ans:"b" is correct . I checked it... Thanks for your reply. Have a good day...

Error Handler Ten Centuries Points: 1086 More actions · Answer 10

Error Handler

Ten Centuries

Points: 1086

July 10, 2013 at 6:34 am

#1631176

Thanks guys! 🙂

Best,
Naseer Ahmad
SQL Server DBA

Error Handler Ten Centuries Points: 1086 More actions · Answer 11

Please explain why you think that option 'C' is the correct one. If you have any futher questions, please let us know we are more than happy to assit you.

Best,
Naseer Ahmad
SQL Server DBA

Mike Hays SSCommitted Points: 1871 More actions · Answer 12

Oppps, got me on this one, think I need some more coffee. Good Question.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

Dana Medley

SSCertifiable

Points: 6764

July 10, 2013 at 7:52 am

#1631230

Thanks for the question!

Everything is awesome!