sp_extendedproperty

[timscronin]

I was trying to script db changes between two sql 2005 servers with script below

sp_addextendedproperty N'MS_DiagramPane1', N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[36] 4[21] 2[20] 3) ) ...

However on 2nd server I get
Msg 15135, Level 16, State 8, Procedure sp_addextendedproperty, Line 38
Object is invalid. Extended properties are not permitted on 'dbo.vSec_User_System_Role_Object', or the object does not exist.

Is there a server setting for this I need to set?

 

[Catadmin]

Have you verified the view in question does indeed exist on the second server? If so, is it actually saved to the DBO schema or someone else's schema? Do you even have rights to access the view?

If you're not SysAdmin on the second server and don't have alter rights on the schema, you're not going to be able to touch it.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"