Robert,

If you are considering 3rd party tools, then the company I work for has a tool that allows you to query all 50 servers/databases in parallel in one click or...

Deltatuk,

How many rows (approximately) are there in the data sources? The reason I am asking is- do you think that moving the entire set of data from the source table(s)...

Just wanted to plug in my 2 cents:

osql and SMO scanning rely on successful UDP communications on port 1434 to the servers and on various (non-user-configurable) timeout parameters. In most...

The leader in recovery is SonaSoft.

http://www.sonasoft.com/

Disclaimer- Please note that neither myself nor the company I work for is affiliated with SonaSoft. Just trying to point to the right...

Or any other audit for that matter OPENDATASOURCE and all other OPEN commands use clear text passwords...

A couple of other suggestions:

1. Can you please take a look at master..sysservers and check whether there are any entries there for the two servers that are behaving differently? Specifically,...

In case it helps, the company I work for (SQL Farms) has a tool with which you can put all your scripts in a project and execute the project against...

In regards to another comment in your original posting-

every Win OS (starting with WIN2K and up) is quipped with the SC.exe command line utility through which you can control pretty...

Jon,

Are you disabling the SQL Server service or other services?

If not the SQL Service- then my suggestion is as follows:

The company I work for (SQL Farms) has a product called...

Sergiy,

You are correct, but this brings up the never-ending tradeoff of getting more up-to-the-point data vs. potentially causing performance implications on the target server- I worked in some environments where...

I apologize in advance for pointing to another site, but:

http://education.sqlfarms.com/education/ShowPost.aspx?PostID=47

The syntax needs a little work, but yes- you can do something similar (see important comments below about security!)

INSERT INTO

Example:

INSERT INTO ...

SELECT * FROM OPENROWSET

HOWEVER!!!

Since you work for a...

I work for a SQL tools vendor, so I will break up my reply into two:

1. In case you are considering 3rd party tools, the company I work for has...

The company I work for, SQL Farms, has a product that does just that. It allows you to access all your databases and servers in an agent-less technology easily from...

I am not sure how SQLRecon does the penetration testing when it hops between networks (i.e., which ports does it use to auto-detect servers?), but it does look like a...