Post reply

Which database is installed MSDE or SQL Server Express?

  • February 12, 2009 at 12:00 am

    #130814

    When I use sql 2005 Management Studo to list the database servers are my company it returns a list containing servers with MSDE, Sql Server Express, Sql 2005, and sql 2008 installed. How can I tell which one of these database "servers" ia actually MSDE?

    TIA,

    barkingdog

  • February 12, 2009 at 2:32 pm

    #943208

    I think that can be done only after checking their versions.

    MJ

  • February 12, 2009 at 2:50 pm

    #943220

    Barkingdog (2/12/2009)

    When I use sql 2005 Management Studo to list the database servers are my company it returns a list containing servers with MSDE, Sql Server Express, Sql 2005, and sql 2008 installed. How can I tell which one of these database "servers" ia actually MSDE?

    TIA,

    barkingdog

    connect to each instance and execute

    select serverproperty('edition'), serverproperty('productversion')

    note the results down for each instance you connect to

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 13, 2009 at 9:58 am

    #943762

    Perry Whittle (2/12/2009)

    connect to each instance and execute

    select serverproperty('edition'), serverproperty('productversion')

    note the results down for each instance you connect to

    That works great. I wonder if this works for Compact Edition?

    ATBCharles Kincaid

  • February 14, 2009 at 11:48 am

    #944127

    Charles Kincaid (2/13/2009)

    Perry Whittle (2/12/2009)

    connect to each instance and execute

    select serverproperty('edition'), serverproperty('productversion')

    note the results down for each instance you connect to

    That works great. I wonder if this works for Compact Edition?

    i think windows embedded SQL is the same as compact so it should do. Give it a try 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 14, 2009 at 5:40 pm

    #944170

    Thanks to everyone for some great replies.

    Barkingdog

Viewing 6 posts - 1 through 5 (of 5 total)

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