<div>
didn't do it the first time but I rebooted again and then it &nbsp;actually became the running value. &nbsp;<br />
<br />
Strange but seems to work now.
</div>


didn't do it the first time but I rebooted again and then it  actually became the running value.  

Strange but seems to work now.

<div>
<div class="content wysiwyg-content">
I am running &nbsp;SQL server 2005 Enterprise on &nbsp; a Windows 2003 Ent machine <br />
<br />
I run the following and it works fine but then I check the running value and its still 0 <br />
<br />
sp_configure 'awe enabled', 1<br />
RECONFIGURE<br />
GO <br />
<br />
How do I get it into the running value?
</div>
</div>


I am running  SQL server 2005 Enterprise on   a Windows 2003 Ent machine 

I run the following and it works fine but then I check the running value and its still 0 

sp_configure 'awe enabled', 1
RECONFIGURE
GO 

How do I get it into the running value?

AWE Memory

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.