I ran into a wierd error message when trying to view the Diagrams on a database that was migrated to SQL Server 2005. Something about the user not being valid and to change the database owner.
A quick search brought up this quick fix:
Try running this command to change the compatibility level to SQL Server 2005.
EXEC sp_dbcmptlevel database_name, 90
Works like a charm! [SQL BOL]
You’ll need to change the timezone on your box to be +5.30 (India Standard Time) until we have a service pack release from Microsoft that moves Sri Lanka back into the +5.30 offset.
Note that changing just the time is a fruitless exercise as the time server will reset it on a periodic basis.
You have been warned! Resistance is futile.
I hope those of you who came to the .NET User Group meeting yesterday enjoyed my session on Cool ASP.NET Tips and Tricks.
As promised the slides and demos can be downloaded from Scott Guthrie’s post or you can directly download the file.