Can you post the results of your test...

Our users once in a while need to make changes to the production. So if their mamager approves that, they call/mail DBA with ticket number.

We execute a...

I also usually restart the server(s) after disabling Write Cache mechanism on the disk. (if enabled).

shot in a dark: check MDAC versions

You could create a Stored Proc (should be on this site too) and put it in Master on each server you want to monitor. Make all the rest of your...

You might want to schedule reindexing on the weekend,  putting your db in simple recovery. Also you might create a script, using sp_denylogin to certain accounts,so your maintenance would run faster....

When I got the above error message, I spent quite a time changing the maint job owner to sa on 30 servers. So those jobs runs succesfully. Rebooting the ADS...

Or could it be that the account you installed under doesn't have sufficient permissions.

We have a pretty hefty db (over 900GB) and we use logshipping for the reporting server. Early in the morning, evening and night we use it for the logshipping; and...

You might want to try to reboot your ADS. It should fix the issue.

We have a procedure in place before reindexing (during maint window), which kicks out all users and put db in a simple mode...

...and subquently, after it finishes the process. remember...

Any accompanying messages in SQl Server Error Log?

It could be a damaged page chain, a corrupt Index Allocation Map (IAM), or an invalid entry in the sysobjects...

UDF performs a  row by row processing, so you might suffer a performce hit on big table...

sufian,

you should stop offending other people, especially those who was trying to help you, and especially Remi! Manners, dude. Learn them. Might be helpful one day. (yes, I got an...

Thanks, We've been waiting for quite some time...