vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|