I agree all of you. I am sorry might not explain you properly.. Please follow this.

The scenario...

We will get the info. in the main page who visited us(like Facebook)

The same...

Thank you for the quick response.

There are multiple names stored there with comma delimiter and the max length of the column is 512 It would be more in future.

It just usernames

Hi Lowell, I got it now... I storngly make sure that It would be row lock rather table lock for single row updation.

Thank you very much for the quick response...

how you are pulling data from linked server & inserting in the current server's database?

Can you explain little bit clearly, better post the query you using as jack requested.

If you want You can eliminate the column values by using the condition in where clause... but not columns.

select col1,col2,col3 from tablename where (condition will be here)

If you want...

Nice GSquared!

I just wondered as middle of implementing this When I just came and found some one already taken care.

Hi Dave-175556

I have applied this network properties But I first couple times It doesn't support giving the same error. Later I have passed through.

Thank you very much for that...

Rookie I found that and wondering how this effects the issue which I am getting. What is the relation there with that?

can You please give me the brief explanation, I...

Hi Rookie Can you please tell me the steps to follow to check the network side. I don't know anything more about networking side. Could you please walk me those...

Hi I have kind of same issue going. First have to do FTP done,. And second what is the performance impact on the server while doing this FTP when DB's...

What size files were going across without any problem? Have you looked into increasing the FTP buffer window?

Hi Chris, Thanks for quick reply.

upto 100 mb - 2gb files were transferring...

I know for sure Triggers are the burden for sure. Unless its necessary to have them in your table don't use them. But anyway it depends on the environment, transactions...

Unfortunately we cannot rollback the committed transaction. Only the way as of I know restore the database.

Check the transaction Log Schedules, If its available. How frequently you do that? Try...