SQL Server 2005 Diagram

[sendba]

I am getting the following error whenever I tried to create a diagram.

Anyone encountered this issue. If so please help.


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)
------------------------------
For help, click:

http://go.microsoft.com/fwlink?Prod...054&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

thanks

Sen

 

[macleod1021]

Do you have rights to the Master db???

 

[sendba]

Yes

 

[ptheriault]

I've seen this before. You are missing the procedures that can generate a diagram. I had to get them from another instance of SQL.



- Paul
- If at first you don't succeed, find out if the loser gets anything.