Post reply

All SQL Servers on Network WITH Service Pack version

  • August 8, 2007 at 6:59 am

    #180033

    I know i can use OSQL-L to get all SQL Servers on the network but anyone have any idea on how to get the Service Pack version on these servers as well

    Thanks

     

     

  • August 8, 2007 at 8:29 am

    #725451

    select

    getdate(),

    cast

    (serverproperty('machinename') as varchar(20)),

    cast

    (serverproperty('productversion') as varchar(20)),

    cast

    (serverproperty('productlevel') as varchar(20)),

    cast

    (serverproperty('edition') as varchar(40))

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 8, 2007 at 9:42 am

    #725472

    Thanks for that, but what i need is to incorporate it with the Osql -L so I get those details for every server on the network

  • August 10, 2007 at 8:14 am

    #726038

    aren't you already running a stored procedure under your osql -L? Just add these lines into the sproc.

  • August 10, 2007 at 8:27 am

    #726045

    What we do (and I got the ideas from posts on this site!) is to have dedicated "DBA" databases on each server that hold tables and stored procedures to capture all local maintenance information i.e. disk space, service pack info, failed jobs etc. etc. You schedule jobs to run each morning on the individual servers and then you have a central SQL box that has linked servers to all your other boxes and it runs a series of collation jobs to pull all the information into central tables. After that it's up to you how you display the information - web pages are the obvious route but Excel via ODBC is just as effective.

    cheers

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

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