October 24, 2013 at 11:02 am
Do we need to run DBCC checkdb and update usage after changing compatibility mode.
October 24, 2013 at 11:03 am
No.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 24, 2013 at 1:31 pm
The only thing compatibility mode affects is how the parser and query processor handle certain T-SQL constructs. It doesn't change the database in any way
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2013 at 1:43 pm
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply