Hello All,

[Hakan Fatih YILDIRIM]

I am building a maintance tool and i want to compare the Service Pack
installed in sql server and the latest Service pack version of the SQL
server.I get the information of installed Service packs with 'select
@@version" statemnet.But is there an API which i can get information
of the latest service pack version from microsoft' site or microsoft
product information?

Many Thanks
Hakan Fatih YILDIRIM

 

[Duggi]

I am building a maintance tool and i want to compare the Service Pack
installed in sql server and the latest Service pack version of the SQL
server.I get the information of installed Service packs with 'select
@@version" statemnet.But is there an API which i can get information
of the latest service pack version from microsoft' site or microsoft
product information?

Many Thanks
Hakan Fatih YILDIRIM

I think you should maintain this information in any config file or
so.
As far as I know no one provides this information as an API. How can
that be possible unless Microsoft or who ever provides the products
has to give an API that connects to online services. (I hope providing
API is not feasable in this case due to different vendors for
different products)


-Cnu