How can I detect which version of sqlServer I am connected to using smo?

Hot Topic

Error: Attribute key cannot be found
SQL Server does not exist or access denied
problem with update
Permissions
Missing Distinct Count option in Measure's Aggregate Function property
Studio query results returns NULL data as actual "NULL" string
Transfer Database task
MSRS + Fit to Page
about processXMLdata sample,how to insert a return in end of each row data of the result text file?
SuppressConfigurationWarnings not working

SQL Server

Update in Sybase 11 Linked Server problem
Where is the old Enterprise Manager :(
quastion about triggers
Native Client connection to MSSQL 2000
SQL Server CTP 16 - Failure to set maintenance plan
Task Expression Evalutation Time
Are report parameters cached in the report server?
FTP Task issue
Generate Scripts -> Script Behaviour -- Missing an option
Need a task that will zip a file prior to upload via FTP

How can I detect which version of sqlServer I am connected to using smo?

Hi,

I have a quick app to do few scripts and generate sps.However some stuff which is new to sql 2005 dont work in sql 2000 as not supported.

Basically. I choose a server from a combobox and connect to the database.

now at this point i need to know if I am running a sql 2005 server or 2000 .

Is there a call I can make is SMO to achieve this

thanks a lot in advance

Answer this question

How can I detect which version of sqlServer I am connected to using smo?

  • Dave M

    Ye, thats right, look at the properties of the version property, they will exose some other string like minor / major etc.

    But you are right 8 is SQL 2000 , 9 is SQL 2005

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • GamerJunky

    Thanks a lot.

    That worked.

    I have found out also about "VersionString" which gives me what I want quickly.

    I suppose "8.00.194". in particular "8" stands for Sql Server 2000

    and "9.00.1399". in particular "9" stands for Sql Server 2005

    Is this correct

    Thanks

  • RTIT

    Hi,

    try this one here:

    Microsoft.SqlServer.Management.Smo.Server _server = new Server(new ServerConnection(new SqlConnection("Data Source={0};Integrated Security=True")));

    //_server.Information.Version --Information can be found here


    HTH, Jens Suessmeyer

    ---
    http://www.sqlserver2005.de
    ---
  • How can I detect which version of sqlServer I am connected to using smo?
Answer this question