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

that way your usp_ only returns a value.

use raiserror of you want to have an error raised and set the jobstep's "on error" action to "quit job with failure"

Check BOL.

e.g....

SQL2005 ? or wrong forumgroup ?

SQL2000 : make sure your sqlserver / sqlagent serviceaccout has got the needed authority for your network-shares.

This job...

Try to alias the tables and you'll find your problem easy so solve.

select MyAlias.mycol,...

from myschema.myverymeaninglesstablenamefartolongtoread MyAlias

...

if you still cannot find it, post...

how about using a udf ?

read : http://www.sqlservercentral.com/scripts/contributions/592.asp