Hello rmiao,
Please note that there is only one server which have two data bases namely hafeez and local

I created a linkedserver from hafeez database to local database and trying to insert the rows into local database.

I started the Distribution Transaction Coordinator service.

The process which i followed to create linked server is:


(i) Open Microsoft SQL Server Management Studio. server login.
(ii) Right click on the Server Objects->Linked Servers and select the New Linked Server…option.

(iii)I gave the provider as Microsoft OLE DB provider for SQL Server.
(iv) In security dialogue box i selected "Be made using the login's correct security context" radio button.
(v) In server options dialouge box I made Rpc Out and Use Remote Collation as True.

Please correct me if u need further info.

Thanks and Regards,
Hafeez.