File that was created when you created a database (Primary File) won't be dropped. You should see a message saying something like' Primary file can't be dropped.'

Only file you can...

How did you run Deny command?

Remember, Deny has to be run on individual objects. ALL won't work.  I have tried that myself and just like you it didn't work...

Right clikc on server in EM on your server machine and check registration properties. Either use SQL user with enough privileges or use yourself (windows authenitcation) if you have permission...

Thanks for KB, alzdba.  I don't think Applications were waiting for response at that point, they were just failing in fraction of seconds.

It's SQL 2000+SP3+MSO3-031 Hotfix. I couldn't find anything anywhere on this.

Thanks.

Try to go in Analysis Manager and see if that OLAP server is in the list. If not Add one there and then go back to EM and try to...

I agree with some other people here, that I prefer getting rid of this cube and get something new. Cylinder (to represent Database) is one idea.

I ran xp_stopmail and xp_startmail as per your advice,sswords. And it worked!!..I am able to run all of those xp_sendmail again.

Thanks for your help.

Interesting. Thanks for the update.

Is this a new SQL install or a upgrade from SQL 7.0? I might have an answer for upgrade.

Also this KB article http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp

gives details on service pack versions for SQL 2000.

Very good information. Thanks.

I had same issue. I rebooted the machine and all the counters came back up.

No, It doesn't rebuild any indexes.

When you run a job manually( click on start Job), it uses permission that you have to connect to database. (i.e. Username with which you registered your SQL server in...