SORT_IN_TEMPDB Index option does not work in an inline table primary key statement - by MSMSPDevTeam

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 794437 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/18/2013 1:20:30 PM
Access Restriction Public

Description

We can specify the SORT_IN_TEMPDB index option within an alter table add constraint statement, and we can specify other index options inline in a table create statement with a primary key; but we cannot specify the SORT_IN_TEMPDB index option inline with the table create primary key statement.
Sign in to post a comment.
Posted by Microsoft on 7/19/2013 at 5:23 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.
Posted by Microsoft on 7/19/2013 at 5:22 PM
Hello,
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product (service packs)
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available
Thanks again for reporting the product issue and continued support in improving our product.