Thanks Ray,

Its working...

Also the article is nice once. I will follow that....

I am getting the same error even after I did the setting mentioned in the site. can any one suggest

http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp

I am getting the same error even I did the same setting in both of my server specified in the link http://www.sqlvillage.com/Articles/Distributed%20Transaction%20Issue%20for%20Linked%20Server%20in%20SQL%20Server%202008.asp

The table should be created with the identity (-1,-1). Then only we can get this result. Must be a typo error???.

Do you mean to say, We need to create the proxy account for each and every user who need to run the xp_cmdshell

I didnot think of that, Now I understand clearly what the problem is ...

Yes, It is because of no of lines in the dynamic query.

Either write in single line or use concatenation operation in the dynamic qry, then it is working

Thans for your input...

The problem was, I worte the query like this

SELECT@QRY_IN= 'select

Employee_code from db1..table1_tmp'

If I change the query in the below format then it is working,

SELECT@QRY_IN= 'select...

In SQL 2k5 the Peer-to-Peer does supports only in Enterprise and Developer Edition. But I have installed Statndard Edition :cool:. I will try this after i install the Enterprise Edition....

You mean, in both nodes i should configure the transaction replication?

No Probs. Peer to Peer Replication means "Transactional publication with updatable subscriptions". As I am new to this I dont know about the Peer to Peer method. Can any one...

If I Configure the Merge Replication, it adds a Unique Identifier column to all the Tables. Is there any way to avoid this? My concern is it should not affect...

Can we have duplicate value in the clustered index column in sql 2k5?

Can we have duplicate value in the clustered index column?