I have used dbcc indexdefrag i sql2000 but are there one in sql 7.0 which
are doing the same thing online ? DBCC dbreindex is not online or ?
I don't want the operation to interfer with the users.
Sincerely
\\Jonas BI'm sorry, Jonas, but INDEXDEFRAG was introduced in SQL2K. Not much we can do about that, there
isn't anything similar in 7.0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonte@.bson.se" <jonasberthelsson@.hotmail.com> wrote in message
news:uG%232EVEhEHA.3520@.TK2MSFTNGP10.phx.gbl...
> I have used dbcc indexdefrag i sql2000 but are there one in sql 7.0 which
> are doing the same thing online ? DBCC dbreindex is not online or ?
> I don't want the operation to interfer with the users.
> Sincerely
> \\Jonas B
>
No comments:
Post a Comment