Regarding Datbases

  • Hi Guru's

    Can any one tell me ..what is the max. number of databases we can create in an instance..?

    Thanx in advanvce..

  • It's 32767.

    If you need anything like this, look up Maximum Capacity Specifications in BOL.

  • SQL Server 2005 BOL (Nov 2008)

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm

    32767 is the max number however there may be limitations imposed on express versions, can't remember..

    CEWII

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply