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.

So there is the problem.

I didn't encounter such a situation yet.

What's the sql-version/sp / hf ?

Did you run the @Cmd in a cmd-box for test ?

I guess it gives a popup at serverside

Is this what you're looking for ?

I prefer using Left outerjoins because I find them to be more readable.

I also like using objectaliases...

your problem object :

select object_name(71577680)

Your problem index :

Declare @Name varchar(128)

select @Name = object_name(71577680)

exec sp_helpindex @Objname = @Name

I would run :

DBCC CHECKDB ( 'yourdb')   WITH ALL_ERRORMSGS 

check BOL for...

there are # of ways to do this. This is one of them :

how about : (#tmp1 is your table)

create table #tmp1 (id...

I switch all db's to "bulk logged" in the first step of the maintenance job (dbreindex/indexdefrag).

then perform maintenance

then switch back to "full" when needed

'create date last month...' can be when you alter the table e.g. using EM. It has the tendency to use a ddl sequence of rename - create - insert -...