creation failed for non clustered index
-
Thursday, February 21, 2013 10:02 PM
hi,
when i am creating index from ssms, i m getting error
creation failed for non clustered index ,timeout expired
All Replies
-
Thursday, February 21, 2013 10:23 PM
The SSMS designers always run things with timeouts.
A general best practice for is: Don't let the SSMS designers actually do things like that for you. Instead use the SSMS designers to generate a TSQL script and run that in a query window.
The object creation dialogs all have a "Script" button, so when you're done configuring the designer, script the creation and run it in a query window.
David
David http://blogs.msdn.com/b/dbrowne/
- Proposed As Answer by Kalman TothMicrosoft Community Contributor, Moderator Thursday, February 21, 2013 11:22 PM
- Marked As Answer by tsql_new Monday, February 25, 2013 4:40 PM
.png)
