Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindexing
Message
 
 
To
18/11/2011 10:13:06
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01529215
Message ID:
01529220
Views:
38
>>>Hi
>>>
>>>Do I need to ensure everyone is disconnected before running a reindex.
>>>
>>>If there are people using the database how does that affect a reindex.
>>>
>>>Thanks
>>
>>It depends on your SQL Server version. Enterprise / Developer version allows indexing while using a table.
>
>So if I can do it despite users being in the system ?

Yes, if your SQL Server is one of the listed. But this is still not recommended.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform