Maximum Database in an SQL 2005 Intance

Hi I would like to know, what is the maximum number of database that you can create in one SQL 2005 Instance?

Hi,

The answer is 32767.

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||I thought 48 Databases? So it depends on the total size of all the database in an instance? Im a bit confused?|||

Hi,

Total no. of instances per computer = 50 (on a stand-alone server for all SQL Server 2005 editions except Workgroup)

Total no. of database per instance = 32767

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||okay. thanks a lot.