Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhavyan_jobs
Starting Member
6 Posts |
 Posted - 2002-11-20 : 06:00:43
|
| The following query is fired on XYZTable of XYZDatabase of remote server named XYZServer UPDATE XYZServer.XYZDatabase.dbo.XYZTable SET [ColumnA] = @VariableA, [ColumnB] = @VariableB, [ColumnC] = @VariableC, [ColumnD] = @VariableD, [ColumnE] = @VariableE WHERE Column1='XYZ' AND Column2='ABC' AND Column3='LMN' AND Column4=PQR AND Column5=UVWThe table XYZTable has Unique Clustered Index Defined on the columns specified in the above WHERE Clause.When the above distributed query is fired, it gets Hanged. But if the whole table is dropped and again recreated with the same design, the above query works fine. But the problem persists when the previous data is again imported into the table that was recreated. I've checked the exisiting data also, there is no integrity failures in it.Plz help me best regardsBhavyaBhavyanidhi KukrejaMember Technical StaffB-1-C, Sector 10Noida-201301U.P.Phone-0120-4536622 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-20 : 06:10:31
|
| How much data in the table?Is it hanging or copying the data to the local server to do the compare?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bhavyan_jobs
Starting Member
6 Posts |
Posted - 2002-11-20 : 06:31:17
|
Thanx for the reply ....There are around 1857 records in the master table(XYZTable) and 7408 in its child table. It is literally hanging and not copying the data to the local server at all. Infact i have to synchronize the data between the same table situated at both the servers(Both local and remote) with the same design after confirming the existence of records on both the server. byequote:
How much data in the table?Is it hanging or copying the data to the local server to do the compare?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
Bhavyanidhi KukrejaMember Technical StaffB-1-C, Sector 10Noida-201301U.P.Phone-0120-4536622 |
|
|
|
|
|
|
Update Problem in Distributed Query