• Hi Guest: Welcome to TRIBE, the online home of TRIBE MAGAZINE. If you'd like to post here, or reply to existing posts on TRIBE, you first have to register. Join us!

SQL Server 2000 Standard 2gb limit

rod_g

TRIBE Member
Anyone know off hand of a registry hack or tool, to break the 2gb RAM limit on SQL Server 2000 Standard Edition?
 

vinder

TRIBE Member
it's a windows limit (32bit) for XP/2000. if you have windows advanced server 2003 there's a 3gb option, but in reality you can only use about 2.5G.
 

rod_g

TRIBE Member
Unfortunately the ERP system we are prepping for has to run on this

I think SQL Server 2005 does away with any ram limits
 
tribe cannabis accessories silver grinders

vinder

TRIBE Member
rod_g said:
Unfortunately the ERP system we are prepping for has to run on this

I think SQL Server 2005 does away with any ram limits
not unless you are running a 64bit OS
 
Top