How do  you check if your sql Server is enabled with Address Windowing
Extensions (AWE) support?

Hi,

Execute the below command in query analyzer:-


sp_configure 'awe enabled'

In the result set if the RUN_VALUE is 1 then Awe is enabled and if the value
0 then Awe is not enabled in ur server.

Thanks
Hari
SQL Server MVP



Show quoteHide quote

exec sp_configure 'awe enabled'


AMB

Show quoteHide quote

why arent trans logs getting truncated with maintenance plan?
Duplicate values
Newbie: Transfering databases from different servers
Are all DSN's really ODBC?
Sysindex not getting updated consistently
SP 4a?
Sort Order Question
Trigger Question
Upgrade MSDE Instance to SP4
Transferring a sql server database to another server