when i am creating index from ssms, i m getting error
creation failed for non clustered index ,timeout expired
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?