Set Max Server Memory – I leave some memory for the O/S that SQL can’t touch.  This is also in the Instance Properties.

So what value do you actually set the Maximum...

oops, missed the part about the CLR procedure. I will look into that.

Thanks.

I now have a new error:

Msg 102, Level 15, State 1, Procedure SaveHistoryDBfileSize, Line 1
Incorrect syntax near 'SaveHistoryDBfileSize'.

When I run the script under SQL Server 2012 Standard Edition, I get the following errors:

Error message: Incorrect syntax near '/'.

Error number = 102

Error Procedure: '---

Error...