I don't know (perhaps detaching/attaching the database)

I've also this message when a part of the database (like an index) became corrupt.

in sql 2000 you can find the job histories & outcomes

in msdb.dbo.sysjobhistory

the count(*) might cause a table scan

the exist clause stops when it finds one

Best bet is contacting the administrator of server A (could be a security setting)

*was too late

Can you give a small example with pseudo values?

DELETE  ProxyPM

FROM ProxyPM

INNER JOIN PM

ON PM.PMEmp=ProxyPM.PMEmp /*same project manager*/

AND PM.Projectcode=ProxyPM.Projectcode /*same project*/

As long the database doesn't change in size (have to check this theory) or is not closed the modified attribute isn't been set (otherwise each write command would cause the...

Does changing the flow help? There is no need to keep objSQLServer open whilst writing your log.

Call writeerrortolog("Cannot connect to " &  rstSQLInstances("ServerName") , Err.Number)  

  objSQLServer.Disconnect

  set objSQLServer =...

Thanks for posting the solution.

sp_recompile can be necessary when the first run of the stored procedure is with atypical values which may be bad for subsequent runs.

sp_recompiles only targets one object. All objects that...

Each time the underlying tables are dml modified the view needs to be recompiled.

Why are you using drop view instead of alter view?

You're welcome.

Make sure the antivirus isn't scanning the ldf, mdf,ndf files.

That is really weird.

What is the service pack of sql server & your client tools?

OS is up to date?

Any antivirus software present?

You can download it at

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en