Pay special attention on the db's logfile(s) when you defrag or rebuild the indexes and you are on sql2k with full-recovery mode.

If you don't...

It's because within sqlserver-memory it cannot allocate memory for your query. When I run it via sqlagent on servers that have this memory-pressure, the chance of getting it executed is...

use the tablockx-hint in one transaction that covers all your insert-statements.

Begin transaction

insert-loop

   insert into xxx with (tablockx) (a,b,c) values (***)

commit transaction

- IMO you may have to check the ansi-settings you are using.

- script the sp and take a look at

"SET QUOTED_IDENTIFIER ...

GO

SET ANSI_NULLS ....

GO"

and work from there...

1) it's not because there are # of applications, that you would need # of db.

    you can arrange it all using authorities.

2) if not on the same db or...

try running your sql using sql-agent.

- if you modify a sp, use the alter procedure syntax, so security keeps in place.

- What's the error, how can you tell it is not working ?

sp_who / sp_who2

- why not put the tables in 1 db (if it is on the same box)? (if you want physical-files per table, use filegroups)

- You can perform the dri-checks you...

Just my 2ct

first use profiler to determine what's going on.

Activate those switches that inform which sql is being used within the sp.

this will put more load on your...

In fact, it should be the calling part that should qualify the owner of the called object.

Because sqlserver 6.5,7.0,2K did not implement schema...

put a clustering index on it and use rebuild index or indexdefrag

also take a look at pad_index and fillfactor

This might help if it were only for me or if I was the onlyone to be registering servers on clients, however, that is not the case.

I would like to...

did you adjust connection-timeout settings in EM or QA ?

I've already tested that (change of keyname) with no luck,

but the key-value is a bunch of hex-stuff, where I think It all has...