Same MS SQL database on Several forums

Discussion in 'Databases' started by MammaRose, Oct 26, 2007.

0
  1. #1
    I am starting a network of forums all using the same MS SQL database so that the same users can access all forums. Do anyone know the size limitations on MS SQL?

    There could potentially be over 1000 tables with several thousands of records on each table. Am I looking at a problem with speed or size?:confused:
     
    MammaRose, Oct 26, 2007 IP
  2. adacprogramming

    adacprogramming Well-Known Member

    Messages:
    1,615
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    125
    #2
    You're not even close to having a problem.

    Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647

    Records often go into the millions for MS SQL.

    You can find more stats at http://msdn2.microsoft.com/en-us/library/ms143432.aspx
     
    adacprogramming, Oct 26, 2007 IP
    MammaRose likes this.
  3. MammaRose

    MammaRose Banned

    Messages:
    1,060
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Excellent..thank you adacprogramming for the information..greenie given for the help.
     
    MammaRose, Oct 26, 2007 IP