How many database can create in ms-sql server for web hosting services, and what resources it use, like how much space will use in default,

For ms -sql reources we are using 4Gb memory Mssql 2005 standard edition, with 32 bit os windows 2008, There are thousands of database. 250 GB Hdd


Thanks

This will actually depend upon the intensity of database operations that are performed on databases hosted on your server. It is also advisable to have powerful processor along with fast hard drives for better performance on database server.