1. Simple but not verra elegant

2. Create linked server views using Openquery and join on the results. Much less BARFY

3. Suppose it would work.

As per BOL:

SQL Server automatically updates this statistical information periodically as the data in the tables changes. The sampling is random across data pages, and taken from the table or...

And then there was the time some contractors installed an Aeronet (radio lan comms) on the roof and picked the same ip as one of our SQL servers. Took a...

Or, you could create an Access adp (Project) and have some incarnation of the Transfer command to shift the data to the project - which would then update SQL Server.

An...

Yeah that should be right.

OR you could try praying (I'm guessing you'd be good at that).

BOL says:

Severity levels from 19 through 25 send a Microsoft® SQL Server™ message to the Microsoft Windows® application log and trigger an alert. Events with severity levels less than 19...

Just that you should be more precise...

'I have 1 NT server running SQL 7 and 1 Win2K server running  SQL 7'  - seems fairly clear...

'Both have very poor communication with...

I just got this error and saw Technet references to a setting under Windows 2003 server which disables Network access to the DTC.

In my case though, I am trying to...

Right Click on Workflow, go to "Workflow Properties" / "Options" tick DSO Rowset Provider.

Don't choose "Properties" as that won't give you what you want.

DB

Not a solution but you can test for parallelism by querying as:

Select * from reasonablylargetable option (maxdop X)

where X is the number of processors you would like used. If...

I think you'll find that Openquery passes the command to an OLE DB Provider which is then processed at the target server - so if you place a where clause...

Terminal Services is unlikely to provide the level of access you need to the files and registry (i.e. probably WONT WORK)

Your only hope here is to start the install from...

No solution but very interesting reading on: http://www.sommarskog.se/error-handling-II.html. The Background article is very good too. Hope the site works for you as I just got a page not found...

That's a bugger. It's likely I will want to do the same someday soon - I'll have a go at it and get back to you.

DB

But testing for a result by interrogating table information might help yes ? What I'm thinking here is that you check the linked server has been defined, then try to...