Post reply

SQL Server Standard

  • February 25, 2005 at 2:48 pm

    #87657

    I know this has probably been asked before, but I couldn't find it in the Forum...

    I have a SQL Server STND edition Instance on a running on Windows 2000 Server.   How Can I tell if the instance is named or default and how many named Instances can I add to this install????

    Is is just as simple as rerunning the Install?

  • February 28, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • February 28, 2005 at 2:58 pm

    #544498

    Run select serverproperty ('instancename') in Query Analyzer.  If the result is null, it's a default instance.  If the result is computer name\instance name, it's a named instance.

    SQL Server 2000 allows a maximum of 16 instances on a single computer.

    Greg

    Greg

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

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