CREATE TRIGGER TrU_T_Server ON T_Server

FOR  delete

AS

if  exists (select * from userdb2.dbo.T_ServerDB B

                   inner join inserted I

               on  B.idnrserver = I.idnr )

 begin

    raiserror("There are still dependant rows" ,16,1)

end

go

I think there even are some articles regarding SET and ANSI at this site.

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