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

Is there a windows thrust ?

To test :

1) map a new drive at the client to a disk(or test-share) of your sqlserver and use your own windows account (not the...

UPDATE det

SET  SFDT_QtyMonth1=tmp.TMSF_QtyMonth1, 

 SFDT_QtyMonth2=tmp.TMSF_QtyMonth2,

 SFDT_QtyMonth3=tmp.TMSF_QtyMonth3,

 SFDT_VendRemarks= tmp.TMSF_VendRemarks,

 SFDT_VersionNo=SFDT_VersionNo+1

from OPT_SalesForecastDetail det

inner join OPT_TmpSalesForecast tmp 

on det.SFDT_SalesPlanCode='SF012005GEN0031'

AND tmp.TMSF_PackCode = det.SFDT_PackCode

WHERE (tmp.TMSF_QtyMonth1 <> det.SFDT_QtyMonth1

OR tmp.TMSF_QtyMonth2 <> det.SFDT_QtyMonth2

OR tmp.TMSF_QtyMonth3 <> det.SFDT_QtyMonth3

OR det.SFDT_VendRemarks <> tmp.TMSF_VendRemarks)