Kimberly L. Tripp (3/10/2010)
Hey there everyone - I know people are feeling like was trying to trick them in the question but I guess the "always" part is what I thought would have been the dead give away. It's really rather simple actually - a Primary Key is NOT always enforced by a clustered index. ...Cheers,
Kimberly
nargade 3404 (3/10/2010)
Paul Randal,When you ask\ write any question mention your assumption.
Nargade,
Kimberly beat me to the punch with this answer of hers. The key word "always" really is a a giveaway to the answer. No assumptions needed. Then look at the syntax for creating a PK, and that explains it as well.
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