This was a good question. I gave wrong answer or better to say incomplete answer (opted for only 4). Method 2 I was not sure because of code written was...

No Gail, Didn't tried it yet. But definitely will do.

A little R&D and I was able to crack the issue. There were two procs mentioned in the trace and the transactions in the two were showing a cyclic dependency....

I have attached the log into after enabling the traceflag 1222. Let me know if you find anything suspicious

Thanks a lot Gail and Anthony. Looking forward to redesigning the tables and/or introducing new column with some unique identifier.

Nope, there is no PK on the table. Even i assume going forward, there is also possibility of getting duplicate values in column ColB to the table T1.

What should be...

Great. Thanks. There was slight confusion. There is actually a unique non clustered key on my table T1 for ColA, ColB and ColC. Now I think I should create primary...

Thanks Anthony. Would it be advised to implement it through trigger ? I mean to check the dependency before any kind of insert, updte or delete operation.

Thanks a lot opc.three. This helped.

1. When to decide if role(s) need to be setup and how to setup the roles. When I ran my applications on my test database, I had the integrated security...

Thanks Brandie, Jeff and All. Found few sites. :-):-):-)

Hi Jeff, please don't take me wrong way. It's like there is so many material on mathematics, physcs, chemistry puzzles. As Microsoft SQL Server T-Sql is so much popular and...

Hi Brandie, Sean, ScottPletcher, I understand there can be no book on T-Sql which you can finish reading and say "Yeah, I'm the man now". It was just like, if...

Check this query:

SELECT CONSTRAINT_NAME, COUNT(*) FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

GROUP BY CONSTRAINT_NAME

HAVING COUNT(*) > 1

Thanks both Chris and Lynn. I was checking and found that there were few records having populated as 'NULL' string. Thats why it was causing issue. Rectified it and now...