Error in Database Diagrams - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Error in Database Diagrams

Author

Topic

cajina
Starting Member

15 Posts

Posted - 2007-04-17 : 12:55:59

When I try to Create a Database Diagram it sends me an Error message like this:

Server Name: TIC\SQLEXPRESS
Error Number: 207
Severity: 16
State: 1
Procedure: sp_upgraddiagrams
Line Number: 55

Invalid column name 'uvalue'.
Invalid column name 'uvalue'.
Could not find stored procedure 'dbo.sp_upgraddiagrams'.
Object is invalid. Extended properties are not permitted on 'dbo.sysdiagrams', or the object does not exist.
Object is invalid. Extended properties are not permitted on 'dbo.sp_upgraddiagrams', or the object does not exist. (.Net SqlClient Data Provider)

How can I find that Stored Procedure 'dbo.sp_upgraddiagrams'?
Why doesn't it work OK?

Thank you!

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-18 : 04:52:21

What is the service pack level on SQL?

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net

cajina
Starting Member

15 Posts

Posted - 2007-04-18 : 10:20:06

It has Service Pack 2.

SatyaSKJ
Starting Member

46 Posts

Posted - 2007-04-19 : 06:34:45

Sound like a new error, you might take this up to MS COnnect http://connect.microsoft.com/ to feedback the issue.s

Satya SKJ
SQL Server MVP
http://www.sqlserver-qa.net

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources