Post reply

How to get the msde server version

  • September 29, 2008 at 10:04 am

    #193759

    Hi

    I try to get the server version by the followin command:

    osql.exe -Sserver\instance -Usa -P*** -Q"USE master SELECT @@version" -p

    This works for the Instance installation. But how do we get the version of the Desktop Engine which has service names like MSSQL$SHAREPOINT? If I add this name as instance the server will not be found.

    Thanks for help

    Jan

  • September 29, 2008 at 10:24 am

    #878503

    JanM (9/29/2008)

    Hi

    I try to get the server version by the followin command:

    osql.exe -Sserver\instance -Usa -P*** -Q"USE master SELECT @@version" -p

    This works for the Instance installation. But how do we get the version of the Desktop Engine which has service names like MSSQL$SHAREPOINT? If I add this name as instance the server will not be found.

    Thanks for help

    Jan

    Try this:

    osql.exe -Sserver\SHAREPOINT -E -Q"USE master SELECT @@version" -p

    Should work if you are local admin on that box.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

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

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