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

You can use the sp_who2 stored procedure to check the current connections from time to time. It runs much faster than enterprise manager activity.

You can also monitor a lot of...

SELECT a FROM testTable  -- works

SELECT a.a FROM testTable a INNER JOIN testTable b ON a.a = b.a -- does not work 

Is there an error message or what do you mean with does not work?

Sandy,

There are many reasons to use stored procedures instead of concatenating strings to create the command. One is performance (by caching query plans), second is security (see sql injection attacks),...

What is BDE you are talking about?

So Ado works with sql authentication?