Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SP on Different Server & MS DTC

Status
Not open for further replies.
itflash

itflash

Programmer
Jul 18, 2001
535
GB

Hi all

(sql server 2000)

I have a trigger on "table_1" within "database_a".

This runs a stored procedure in "database_b" which performs an update on "table_2" in "database_b".

It all works fine.

Both databases are on the same network, but we want to keep them distinctly different.

We now want to add transactions across the servers using the MS DTC (Distributed Transaction Cordinator)

Is there any additional overhead in doing this and is it possible?
Also, any useful links on turnig it on, etc. would be appreciated.

Thanks
ITflash




 
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
600
Chris Miller
Chris Miller
MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
476
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
796
Volvere
V
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
1K
gmmastros
gmmastros
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
890
SashaBuilder3
SashaBuilder3

Part and Inventory Search

Sponsor

Back
Top