If your VB code connects with the same user account as you logged in with when running the proc from Query Analyzer - then the result should indeed be sent to...

This works just fine;

exec sp_msforeachdb 'use ? select db_name() as ''now processing'' exec sp_helpdb ?'

..so maybe try:

exec sp_msforeachdb 'use ? select db_name() as ''now processing''...

Agreed, this makes no sense and is very confusing.

Like the cities supplied as example:

2 city1

2 city2

2 city3

2 city4

Four cities with the same ID..?

IMO, what needs to be...

Is this a one-time operation, or do you plan doing it on a regular basis? 30 million rows will indeed take quite a while...

/Kenneth

On a note on formats for input into datetime datatypes

Don't use anything else than yyyymmdd as input format for dates. Do your utmost to enforce this, and your dating troubles...

Try firing up profiler and then create an object. The trace should be able to tell you what is happening.

/Kenneth

Have a look here http://support.microsoft.com/default.aspx?scid=kb;en-us;254321 

There's a paragraph dealing with applying sp's on clusters and different versions of SQL Server.

/Kenneth

You should probably ask this  question in a Access forum instead, where they have more experience with Access.

/Kenneth

Happens to all of us, especially on Fridays

/Kenneth

Well, it doesn't get 'simple' until SQL Server 2005, when we get a ROW_NUMBER() function.

However, in the meantime you can do like this:

Have you tried it? Many times it's pretty easy to mock up something simple to test code behaviours..

declare @status char(1), @Tol_status char(1)

set @status = 'R'

Set @Tol_status = 'U'

if(@Status = @Tol_Status)

 ...

I have no experience with neither of those tools, but I wonder what kind of crystal ball they have built in if they do any better guessing than anyone else,...

Have a look in BOL (Books on Line) about distributed transactions (lots to read) and check that you have everything required in place for this to work.

/Kenneth

Easy, it can't be done.

Boy or girl? Kim, Robin, Stac(e)y, Hilary.. I'm sure there are lots of more gender-generic names out there...

/Kenneth