Might have helped here. I'm building a dw so maybe a reverse engineer would have been possible in that scenario.

So bottom line, why is there no CI on that...

f.limani (5/11/2011)

---

ninja, thanks !!!

im so happy that i could eat a whole lamb right now ..

i think we shold report this as a QOS requirement to Microsoft.....

Hey Gail, if there had been a clustered index on that table. Could we have guessed at the lost data?.. or done something else?

You're not done. You still need to run checkdb pre backup. Stop the backups / delete...

You forgot my super ninja trick :-D.

There used to be a free download version of this but I can't find it atm...

http://www.red-gate.com/our-company/about/book-store/sql-server-execution-plans

Looks this up in books online.

SET CONCAT_NULL_YIELDS_NULL

Also the ISNULL / NULLIF functions could be handy here.

This is the best link I have on the subject. Works everytime.

http://tinyurl.com/3tflqq2

So what have you tried? That errors is more than clear to me.

Yes it's called a step.

Put the next job in the step or use sp_start job in the next step and drop the schedule for the other job.

I can't help you with that, but I can tell you that whoever can will need to full error message, not just the number.

Tx.

Same here... if it matters.

Mike01 (5/11/2011)

---

I tried it and I get the error "Value of 125 is not valid for value. V alue should be between Minimum and Maximum Parameter name" When I...

It's a download interface with pause / resume options.