When I've used 'on completion' I've had some 'unexpected' results so I'll try and stick with on success where posssible.

Had a read around 'on error' and definitely looks like something...

I had problems with an activex script that wrote to a log file whilst another job still had a lock on it. It bombed out and the job failed even...

When I've tried doing this it puts the log file in the same dir as the data file. Can you use this method to attach the database with the log...

Thanks to all for your suggestions.

mccorks view methodology has worked best here as performance hit is very small on large loads (200,000 - 2m).

DDQ of drmccue works fine on anything...

enterprise manager - create a local package.

add SQL task and connection to approprite db.

type 'exec proc_name' in sql statement task

right click on package and schedule.

you can then modify job in...

Cheers, all sorted. I'd got so bogged down in trying to make the outer syntax work I hadn't even thought about using cross joins.

Once again, thanks.

Thanks for your help, sorry for the delay in getting back to you.

Tried your suggestions and re-ordering joins but no luck.

what I'm trying to do is create a fact table...

I did run update stats after populating all the tables and also created the proc with recompile, but still no go!

I split out the creation of tables and population and...

If you use 3 prefix it will work. A bit longwinded but it does work. I've tried 2 prefix like in Allen's example before and it doesn't work for me.

Kevin

...

If you loop on a timer then isn't this the same as looping until file exists, the cpu is still active.

Ideally I'd like to use WScript.Sleep or something similar from...

I want to check if the flag file exists. If it does then do processing. If not then sleep for 5mins then check again rather than continually looking for the...

I think that if you create a compound index on all the join columns in day_sales (and the aggregate column) the optimizer can get rid of the bookmark lookup and...

Thanks for the explanation.

Read (sqlsever-perfomance.com)that stats should be updated on table over 500 rows when 500 + 20% rows updated/inserted. In this case 500 + 1m = 1000500, so...

After lots of trial and error. managed to fix the problem.

when I reduced the number of rows in the dominant table to 10 from 815 the query optimizer chose a...

forgot to metion - we do have auto update statistices turned on.

thanks