If you need to run it across 35 servers and considering 3rd party tools- you can look at SQL Farms. You can run your sql script to get login info...

Use SET TRANSACTION ISOLATION LEVEL instead of (NOLOCK) - this has the exact same effect as (NOLOCK) over linked servers.

Example:

If you wish to do the following (which is not permitted):

SELECT...

If you are considering third party tools- look at SQL Farms- they have a tool that allows you to run anything across databases and servers.

I wrote a script long ago that does most of the things you are looking for and it is avaialble here:

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

(sorry for pointing to another knowlegde base site, but that's...

If you're considering the use of 3rd party tools, you can look at SQL Farms- they have a tool that allows you to run the same change script against all...

If you're considering 3rd party tools, then you can use tools like SQL Farm Combine to run all your scripts that you write in parallel against all databases and servers...

HA HA !!! No sour grapes The point I was trying to make is that there...

There are many monitoring solutions at similar price points that provide so much more information than this tool. I am not sure I understand why this tool is useful- using...

If you're considering the use of 3rd party tools, look at SQL Farms- they have a tool with which you can connect to all databases/server in parallel and run any...

Steve,

While I do believe that the article you posted is good and provides constructive guidance, one thing is still a little itchy... Red-Gate bought this site so it can better...

I used to work as the lead DB architect for the 4th largest SW company in the world, and we were facing the same issue when we started building the...

Terrible idea. Good products will not mandate that you install any types of agents on your databases and servers. You can never hold a vendor responsible for loss of data...

If can run a query against all your databases and servers using third party tools like SQL Farm Combine. You can query hundreds of databases and get a single result...

If you use tools like SQL Farm Combine you can run this script, or any other scripts against any number of servers with zero effort or coding (adding/removing remote servers,...

What are you trying to monitor? Can you elaborate?