Wednesday, March 7, 2012

Is there any third party s/w that lists SQL servers in a network and query more info about

Is there any third party s/w that lists SQL servers in a network and
query more info about the server? I need to find out the sql version,
whether its a msde or a msee. Also the service pack details and list
the databases in that server. Any help appreciated...

Thanks..!No need to buy a 3rd party apps for this.

use "osql -l" (try capital L if this doesn't work) at the command prompt.

If you want to obtain SQL info just use the following sp and xp. You can also
obtain these information remotely (without EM or QA) using osql.

exec master..xp_msver
exec sp_server_info

No comments:

Post a Comment