to get a list of servers you can use this: select * from sys.serversĤ. In the brakets you have the instance nameĪ list of server and a list of instance installed is not the same!Ī server can be an element in the instance it self. Look for all the services named "SQL Server". * Use the Services list to get all the services installed (My prefered option!) * Use the SQL Server Configuration Management -> SQL Server Network Configuration * Dig through the registry: go to the 64-bit HKLM\SOFTWARE\Microsoft\Microsoft SQL Server InstalledInstances, and 32-bit instances go in the 32-bit one.
If I underst correctly then you ar not looking for a list of databases but a list of instances installed. The same way we can and try to find something. In the mean time. If any one will do this job he should already do is a blog, WIKI article or any other format which is more fitt fot this. Yous use Googl e in order to get tutorial with screen shot. This is a forum and not a tutorial or a guid. There is a free version and there is a paid version, so the answer for "is it free" is both NO and Yes :-) The answer to "is it commercial software" is absulutly yes (free can still be commercial).Ģ.
0 kommentar(er)
