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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 sp_addextendedproperty
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

stahorse
Yak Posting Veteran

86 Posts

Posted - 10/31/2013 :  02:59:28  Show Profile  Reply with Quote
I have this sp_addextendedproperty below and I this error:

'' Msg 15097, Level 16, State 1, Procedure sp_addextendedproperty, Line 16
The size associated with an extended property cannot be more than 7,500 bytes. '':

Help....

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "AWDBI_WREC_ALL (dbo)"
Begin Extent =
Top = 6
Left = 38
Bottom = 119
Right = 194
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "vwAWDBI_AWD_SUBTYPES (dbo)"
Begin Extent =
Top = 6
Left = 232
Bottom = 119
Right = 388
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AWDBI_W08 (dbo)"
Begin Extent =
Top = 120
Left = 38
Bottom = 233
Right = 190
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AWDBI_W06 (dbo)"
Begin Extent =
Top = 120
Left = 228
Bottom = 233
Right = 380
End
DisplayFlags = 280
TopColumn = 0
End
Begin Table = "AWDBI_SCHEMEREGNAME (dbo)"
Begin Extent =
Top = 234
Left = 38
Bottom = 332
Right = 190
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
SortType = 1350
SortOrder = 1410
GroupBy = 1350
Filter = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vwAWDBI_WREC_RFA_BM'

Edited by - stahorse on 10/31/2013 03:51:30

TG
Flowing Fount of Yak Knowledge

USA
6065 Posts

Posted - 10/31/2013 :  12:42:19  Show Profile  Reply with Quote
What specifically do you want help with? The error message is pretty clear that your property value is too long.
Some potential solutions:
- split that property into multiple properties.
- don't use extended properties but rather use a user table like [ObjectProperty]

Be One with the Optimizer
TG
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000