You have just run into the reason the maintance plan is seldom used by exprienced DBAs. To repair your indexes by the maintance plan the database must be in single user mode and most production and test databases are never in single user mode. Solution SQL Server Agent Jobs and DBCC statements scheduled as jobs are your friends. This means SQL Server Agent must be installed with a service account with Domain level permissions. Run a search for the index related DBCC statements in the BOL (books online). Hope this helps.
Kind regards,
Gift Peddie
Kind regards, Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply