SQL Server 2005 defragmenting index primary key

Can defragmenting, rebuilding or reorganizing a SQL Server 2005 index which is used as an identity specification primary key field for a table change the values in the field? (Destroying queries based on the primary key values)
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
No.  None of those activities will change the actual values in any column.  

More specifically for identity, once an identity value has been assigned, it will never change.
lcohanConnect With a Mentor Database AnalystCommented:
"Destroying queries based on the primary key values" - only thing may be gone is(are) old cached query plans but this is a good not a bad thing. If you have some "sticky" cache you may need iisreset if a update statistics and sp_recompile on that table do not help.
machine_runAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.