discovery of sql server instances and testing the instances for collation connection moed etc.

Aug 7 2008 4:04 AM
Hi,
    I'm developing installation package for app, it needs to check weather a sql server database exists on local machine and/or local network, what is the full name of the server (weather it is a named or unnamed instance) what version number it is weather it is a mixed mode authentication what collation it is, since I don't necessarily know the sa password I'll need to connect using windows authentication.
     Thanks in advance for any suggestons.   

Answers (1)