based on system catalog info (designed for sql2k sp3)

select  u.name as TbOwner, o.name as TbName ,  x.name as IxName, xc.name as IxColName, xk.keyno...

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

- did you see a popup window at serverside "user32.dll failed to initialise..."  ?  Check KB184802

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q184/8/02.asp&NoWebContent=1 

In that case, sqlagent will wait for a "ok" reply to that...

maybe http://www.sqldts.com has what you're looking for

- _WA** are just statistics, that 's not the same as a regular index.

- However it does give you a hint on which columns are used for searchoperations.

- Use "create...

1) - there is no need to perform detach/attach to make a backup !!

  That way you'll waste backupspace and you'll have downtime.

   -...

Youre welcome, thats what this group is all about

Actualy, there's a little bug because a for delete trigger only has the deleted object...

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.