Awesome.  Thanks for the feedback.

The next question is, do you now understand how to do such a...

It has nothing to do with xp_CmdShell.  There's something wrong with the RESTORE command or the file wasn't found by the xp_CmdShell command.

If it were me, I'd modify the job...

Post removed.

🙂

Not sure how long you're planning to have this code active but it will "only" continue to work if the dates are less than 68 years, 1 month, 2o days,...

I could certainly be wrong but I'm not sure this can be done.  I don't remember where I read it (mostly because I don't use containers, or at least not...

Nice and complete article, Daniel.  I, unfortunately, don't have the time to give it a try myself... at least now right now.

What WOULD be interesting is to give it the...

Typical "prelude to SPAM under another name or tag team".

As a bit of a sidebar, the default sucks for performance.  ROWS is faster than RANGE in the testing I've done in the past.  It would have been nice if...

Oh, and I missed the formatting thing. Yeah, it does it. Just double click on the batch_text or whatever field and it will open a window like this one:

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run,...

Yeah, you can set up SQL Trace or Extended Events to catch those errors. It's like a net for those SQLExceptions. But in the long run, asking devs...

hi folks

really appreciate the feedback here guys, although i am now in a state of, what the hell do i do now - which is no bad thing, lets...

Jeff

look at my reply above , thats a five day window!

the scripts i use for indexing are just the standard ola hallengren scripts

And as i said, normal erp sql...