Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding timeout on table structure
Message
 
 
To
25/02/2009 13:00:13
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01384100
Message ID:
01384107
Views:
44
>But, I had to remove an index as it was blocking that command. Then, I recreated the index after. Is this the normal way to do it?

You can increase a size of column with index if column type is a varchar, nvarchar, or varbinary. For other types you have to drop an index and re-create it afterward.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform