• When I ran your T-SQL, I got a message set I've seen before:

    Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

    Msg 5845, Level 16, State 1, Line 1

    Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

    Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

    Msg 5845, Level 16, State 1, Line 1

    Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process.

    Jim