February 22, 2006 at 11:52 pm
Is it possible to run a script that will retrieve all SQL servers including their objects from a server or multiple servers
February 23, 2006 at 6:31 am
the command osql -l should do it for you and list all the available servers on the network, but i believe that there are some issues, as i've tested before, this command doesn't gather all information, but only servers that have been already registered before. so, its USELESS.
anyway,theres a software at http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26 called SQL Recon that scans the whole network looking for sql servers.
cya xD
February 24, 2006 at 8:10 am
Hi buddy,
The osql-l will give u the listing of sql server whose services are on but doesnt give the server name whose sql services are stopped.
for details i had discussed this question before on the same forum this will help u
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=249112#bm249509
from
Killer
February 26, 2006 at 11:35 pm
Thanks a lot guys
appreciate the help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply