I've downgraded an instance from Ent to Std and it broke the broker so to speak, so had to re-set\re-enable it.

Don't worry, I've fixed it.

I'd restored MSDB over from a named instance. In sysalerts I had to change the event_source column from the named instance name with $ in it...

Yes thanks for thta, I'd actually done something similar already. Was hoping for something that would alert me instantly.

Cheers, yes we're already going down that route, this was a v quick, I had an hour to come up with something. The sql statement you see is a very...

Yes the unit are attached to IT and support the business so they are a little more technical and use SSMS

Thanks fot that.

But as i say, using the ANSI format is what I want to get away from, it needs to be dd/mm/yy for ease of use by our business.

Also...

execute myproc '13/05/99', '14/05/99'

But theres no app, all I'm executing is that SP via SSMS

Thaks for that. So can you give me an example of how you would have coded it please. 🙂

Hi, thank-you for that. Was just typing in the fact that I'd resolved it.

I had to set the 2 variables to varchar, I had them as datetime! doh

Then I...

Hi, no it doesn't. It checks at least for .bak and .trn files being on the same drive as .mdf etc. But I'm not 100% sure of the...

Just thought I'd add my thanks for turning this problem into an easy task having had the same 'wrap' issue! Used the view technique....superb!

Thanks both for that. Yes LocalAdmin is a work around but we then spend time changing settings back to a domain account once it's installed so lose time that...

Hi, this is by default the TEMP folder for the SQL Agent account, e.g., "C:\Users\accountname\AppData\Local\Temp".

Yes I'm sure that'll be fine, thanks for your help Bob 🙂