Post reply

What happens if you have both 2000 and 2005 installed on the same machine?

  • June 9, 2006 at 9:55 am

    #168556

    In that case, which version does it defualt to when an application is accessing a database? When i link a database to sql server 2k5, sql server 2000 seems to automatically picks it up also. Im trying to test some triggers and scrips to see if they would still work under 2k5 but im not sure which version of sql server the application is linked to.

  • June 9, 2006 at 7:40 pm

    #642943

    Its not a question of which one it defaults to.  When installing the second one, you probably installed it as a Named Instance.  If you didn't install one has  named instance, you probably upgraded the 2000 to 2005.  To access the named instance it would be machinename\instancename.  If you just connect to the server as the machinename you are connecting to the main instance, which is probably the first one you installed (my guess 2000).  One thing you can do in a query window to check is do a SELECT @@VERSION.

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

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