Confusing error message when incorrectly renaming a table

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Confusing error message when incorrectly renaming a table

Postby corrin » Thu Sep 02, 2010 10:34 pm

Hi,

Not sure if this is version 5 specific.

I was in the process of moving lots of objects out of DBO and into specific schemas. Since SSMS does not refresh its metadata during this, I accidentially ended up trying to move a table twice.

The error message was "You cannot rename a system object" which I found quite confusing.
corrin
 
Posts: 3
Joined: Mon May 10, 2010 10:02 am

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests