Post reply

sqlserver 2000 instances

  • May 8, 2009 at 1:13 am

    #209202

    Hi ,

    1) i would like to know for sqlserver 2000 EE how many instances we can create.

    2) in my server when i tried to edit stored procedure in one of instance whole sqlserver application is closing.

    error iam getting is attached file

    PFA...

    can any body pls reply

    Thanks in advance

  • May 8, 2009 at 4:04 am

    #990961

    1) With SQL 2000 you can have a maximum of 16 instances on one server. SQL 2005 supports up to 50 instances.

    2) Seems like either an IO issue or database corruption. Run DBCC CHECKDB and check your SQL Errorlog for more messages.

    [font="Verdana"]Markus Bohse[/font]

  • May 11, 2009 at 1:08 am

    #991917

    Thanks for u r reply

    but i could not connect to that instance in my local server.

    i tried with sql registration but it is not working

    can u please suggest what to do

    Thanks in advance

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

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