Post reply

Need help getting Edition, Build, SP Level, etc From SQL 7 server using TSQL

  • October 24, 2007 at 9:10 am

    #62971

    I am building a maintenance routine which reports Server Information to a central database. The routine works fine with SQL 2000/2007 becuase i can use the serverproperty function. Unfortunately, SQL Server 7 doesnt support the function. Any Ideas on how I can obtain the same type of information?

    I suppose one option would be to parse the @@version results, but I'm not sure how reliable this would be.

    Any help would be appreciated.

  • October 24, 2007 at 9:17 am

    #745008

    Have a look at this

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84713

    N 56°04'39.16"
    E 12°55'05.25"

  • October 24, 2007 at 9:27 am

    #745013

    I believe that did the trick. I really appreciate the help.

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

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