Is changing the compatibility level of a database an online operation?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Yep (http://msdn.microsoft.com/en-us/library/bb510680.aspx), but be careful. Could cause issues with active queries.
And remember that after you change the compatibility level of the db you should update the statistics.
No one has followed this question yet.
cannot drop datafile in empty filegroup
Good book on dynamic SQL
SQL Server Error Logs
What are the uses of DBCC commands?
sql-server Developer to DBA