January 28, 2006 at 9:08 pm
to test in workgroup envirement in QA.
I know this much: I need to link server, but after i do my query says error message says "the object(table) does not exist"
in help it says in a distr. query i need to reference the by system.catalog.table or something, but someone else said to reference it , servername.db.owner.table
which is the correct way to query a table in another db?
tanks!!!
my test situation is a checking account table in one servers db, and a savings table in another servers db. doing a distr. query
updating the checking's balance column - 1000 in a trans, then updating the savings tables balance column + 1000
January 28, 2006 at 9:27 pm
The correct way is Servername.DBName.Owner.TableName.
First add the server as a linked server an then run the query.
If you need to begin a distributed transaction, using the two phase commit, then start the transaction with
BEGIN DISTRIBUTED TRANSACTION
The MSDTC service, must be started in both servers.
January 29, 2006 at 11:20 am
Super, I am gonna try it!!! thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply