Have you tested the individual components of the flow to see where the bottleneck is? How long does it take to run the query locally? How long does...

Possibly. I get 2013-11-28 00:00:00.000.

John

Yes, I suppose that so long as your trigger doesn't cause itself to fire again, you should be OK. I wouldn't swear to that, though - you'll want to...

No cursors? Why not? You're looping through 100 servers, so even if you don't have an explicit cursor, the effect is going to be the same. This...

You can't pass a parameter to a job. Can I ask why you're reluctant to create a stored procedure? That would be the normal way of doing it.

John

You're doing this the wrong way. First, stop using sysobjects, which is provided for backwards compatibility with SQL Server 2000 only. Second, why do you need to use...

It's not clear what your requirement is, but since up UPDATE statement is effectively a DELETE followed by an INSERT, you'll need to query both the Inserted and Deleted virtual...

sqlcmd is nothing but a utility that runs SQL scripts. If it doesn't meet your requirement, please provide more information on that requirement and the reason for it. ...

No. If you're going to do it regularly, create an SSIS package or do it with the sqlcmd utility. You can run either of those from a job.

John

Please will you post the whole query, redacted or obfuscated as necessary?

Thanks

John

If you run the exact same query in a query window, do you get a row count in the Messages pane?

John

Jon

This sounds fairly easy, but you haven't provided us enough information. Please post a CREATE TABLE script for each table involved, sample data in the form of INSERT statements...

There's two ways I'd recommend:

(1) Set up a Central Management Server (CMS) in SSMS and then register all the servers in your list in a group under the CMS. ...

You've got half a dozen "database" keywords in the second half of your query. What are they for? Run your query in a query window to check that...

That's not the same query you posted earlier. What is "loo" - is it a linked server? If you're querying a remote server then the four-part naming convention...