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