Home Dashboard Directory Help
Search

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


Status: 

Resolved
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 794437
Opened: 7/18/2013 1:20:30 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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.
Sign in to post a workaround.