the server1 is not sql server it is a network server which runs this script. Server 2 is 2000

I am running script on the server1 against server 2. Sometimes it locks server1 and we think this script is causing a problem. Thank you

Thisa script running on server1 This runs a SQL against server2, on the Database . It uses connection string

and on occasions locks up server 1

Do you know any...

2000

Is this better? Thank you

DECLARE @TableName_tmp sysname

DECLARE @Tablespid_tmp int" _

DECLARE @TableId int

DECLARE @TableId_startpos int

DECLARE @TableId_endpos int

DECLARE @Query_tmp nvarchar(1000)

DECLARE @SortedTable_tmp ...

No problem, I don't have a direct connection

what type of communication

Sorry,Let me correct myself. I see both locations where the data is coming from and where the data is going.Transaction logs run every 15 minutes. Thank you

Thank you for your information: I have a RadGate and wanted to use that. I can't have anytime down. The location from where we moving server can't see the location...

ikrami2000 (10/5/2008)

---

DECLARE @tableHTML NVARCHAR(MAX) ;

SET @tableHTML =

N' ' +

N' ' +

N' ' +

N'...

Thank you so much

Thank you. Here is a ttachment

I will have VPN to do the work. I have 300 GB of data. Thank you Please help me as much as you can

I want to send data from the view. Thank you so much