curious_sqldba (10/6/2013)
Can we disable PK which is nc index?thanks
you cant disable PK infact you can drop the constraint and think how would you maintain the uniqueness
because
if duplicate records get inserted and it will need extra and useless attention to remove duplicacy and create PK
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)