Nice article but my company's security policy requires Database Mail to be deactivated. We use the SSIS 'Send Mail' task instead.

Nice article. Please consider the surface well and truly scratched!

Thanks everyone. It was a classic EBKAC, I'm afraid. (Error Between Keyboard And Chair).

In the startup parameters of Config Manager, I was replacing -d with -m, rather than appending -m;....

OK, but to start SQL Server in single-user mode do I use the following as a start-up parameter?

-m;-d + Location of master data file;

-l + Location of master log file;

-e...

Yes, these 3 parameters are correct.

To set single-user mode, do you know if I substitute -d for -m in the start-up parameter, or append -m; ?

Ah, thanks Elliot. That would make sense in this case as we have some legacy databases at level 80 on the affected instances.

I'm still interested if anyone can shed light on why this would run on an Enterprise instance but not on a Standard or Developer instance. :unsure:

OK, I found the issue...I was calling the DB_ID() function inside a select from a system view:

SELECT

field1,

field2

INTO

table_1

FROM

sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL...

Thanks Yann.