*One way could be with setting permission based on an application role

in query analyzer they will need

to execute sp_setapprole on the connection

*you have the

APP_NAME ( )  function  that...

Are there any char/varchar columns in the table?

If you generate the create table scripts for both tables, it is an exact match (except for the indexes)?

The cost% is to be taken with a grain of salt.

Table scan, index scan... generally give a better indication.Usually the query with the fewest reads will be faster.

What was the...

Welcome.

Have a look at

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

Performance is mostly based on the amount of reads (I/O) and then cpu/duration.

If possible avoid the use of cursors(very important),record by record based solutions and use...

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...