thanks for your time.

Instance_2 is using port 2446

Instance_3 is using port 2072

they reside at the same server.

Regarding the udp 445 : I have always been able to connect to instance_2,...

you might want to use :

exec sp_depends  @objname =  'object'

documented in BOL

these declares tell us zip.

post the sp code so we can get an impression as to what may be going on.

If you only have one location per machine that is not null, this will work.

update T1

  set location = T2.location

from yourtableowner.yourtable T1

inner join yourtableowner.yourtable T2

on T1.machine = T2.machine

and T1.location is null

and...

I use this.

It gives me not only the ip-address, but also the domain-suffix for the server

 CREATE TABLE #tIpInfo (vlgnr smallint not null identity primary key, IpAdres varchar(500))

declare @DosCmd varchar(100)

 if...

keep in mind that that is dynamic sql  !  http://www.sommarskog.se/dynamic_sql.html 

keep in mind that that is dynamic sql  !  :ermm http://www.sommarskog.se/dynamic_sql.html&nbsp

IFAIK you can only restore 1-1 (logical name vs filename) using restore database.

What you could do is :

- restore the full database to its new server

1) You'll have to stop/start sqlagent if it is the first alert you've defined where sql has to perform some stuff.

2) keep up...

I'm glad it worked.

tip of the day : Avoid running with uid=sa in _any_ environment.

yep, I noticed I'd forgotten to mention it

btw we have just been hooked up to a...

yep, I noticed I'd forgotten to mention it

rs12.ActiveConnection = "dsn=IMMDATA;uid=sa;" 

I suppose you mean e.g. you have used us-insert time of a row and now you want to calculate the insert delay (network) ?

How about :

alter the insert statement :

INSERT #temp

(

 Fiscal_Yr_Ending,

 Fiscal_Period,

 Trans_Amount,

 Acct_ID

)

SELECT

 t.Fiscal_Yr_Ending,

 t.Fiscal_Period,

sum( CASE WHEN tl.Trans_Type = 'D' THEN (tl.Trans_Amount * -1)

 ELSE tl.Trans_Amount  END  )  Trans_Amount,

 tl.Acct_ID

FROM

 Transactions t JOIN Transactions_Line tl

 ON t.Trans_ID = tl.Trans_ID

group...