-- Checking for AWE:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
-- A config_value of 0 means that AWE is not enabled
EXEC sp_configure 'awe enabled'
GO

-- Enabling AWE:
-- (Make sure to grant 'lock pages in memory' to
--	SQLService account and restart SQL after this change)
EXEC sp_configure 'awe enabled', 1
RECONFIGURE
GO