SQL Server Performance Forum – Threads Archive

Remote Server

Hi,
I am having remote server but on the same LAN.I want to access data through Distributed transaction coordinator. How can i add the remote server to my database so that i can insert the data in my existing server. For example,I have DB server DB1 and another server DB2. Now i have requirement to insert data from into DB1 server from DB2 server.
how can i do that.Please provide you inputs Thanks and Regards
Ravi K

Please have a look at section "linked servers" in BOL .

You can accomplish similar functionality on SQL Server by first enabling the Distributed Transaction Coordinator (DTC) service to run on the server. Once DTC is running, you can use one of two commands to start a distributed transaction: BEGIN DISTRIBUTED TRANSACTION — to start a single distribute transaction
SET REMOTE_PROC_TRANSACTIONS {ON | OFF} — to enable distributed transactions for all transactions started by the session
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

hi!good day to eveeryone!i have a vb6 program connected to a Sql server.my problem is when i run it an error shows up like DBNETLIB ConnectionOpen SQL server does not exist or access denied. This meesage didnt appear before but when I removed the LAN cable from the LAN card it appeared. The SQL server is installed in the same pc where the program is located… Another problem is im confused because when I run the program from the laptop(Where it is really installed. I only copied it and transferred it to the desktop pc) it is functioning well… what is the main cause of this problem and how can i solve it?

REfer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 for potential causes of SQL server does not exists error. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

tnx!

jay_see_25, instead of asking a question at existing topic, ask it as a seperate topic so that you may get many replies Madhivanan Failing to plan is Planning to fail

To my surprise Jay_Cee posted same query in 3 other sections and got a reply to refer this post [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>