Depends to your edition as well but most of 2005 editions supports max amount of RAM that OS supports.

refer http://msdn.microsoft.com/en-us/library/ms143506%28v=SQL.90%29.aspx

Rohit