Incorrect Information in Books Online for sp_addextendedproperties (Plan Guides) - by grrlgeek

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 804345 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/2/2013 11:31:43 AM
Access Restriction Public


Books Online for sp_addextendedproperties has incorrect information, related to adding an extended property for a plan guide. states that plan guides are class 27. However, does not list PLAN_GUIDE as a level0type, level1type, or level2type. 

I was able to add an extended property to a plan guide by using a level0type of 'Plan Guide', however. 
Sign in to post a comment.
Posted by Rick [MSFT] on 10/3/2013 at 8:18 AM
Good catch. I have added PLAN GUIDE to the list of level 0 objects in the sp_addextendedproperty (Transact-SQL) topic. This will appear in the online version of SQL Server 2012 in a week or two. Thank you.