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)

Thanks for the feedback.

Glad you've solved it.

check out http://www.sqldts.com.

There are a number of scenario's that may apply.