Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


5
0
Sign in
to vote
Type: Bug
ID: 804345
Opened: 10/2/2013 11:31:43 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Books Online for sp_addextendedproperties has incorrect information, related to adding an extended property for a plan guide. http://technet.microsoft.com/en-us/library/ms177541.aspx states that plan guides are class 27. However, http://technet.microsoft.com/en-us/library/ms180047.aspx 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.
Details
Sign in to post a comment.
Posted by Microsoft 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.
Sign in to post a workaround.