Insertion problem in a multi server environment  
Author Message
DamenGilland





PostPosted: Fri Jan 14 09:27:20 CST 2005 Top

SQL Server Developer >> Insertion problem in a multi server environment

HI,
I am using a procedure that inserts data from a database to another. This
insert is divided into many parts because of the large amount of data.

When the two databases are on the same server, all data are correctly
inserted.
When the two databases are located on different servers, only a part of my
data is correctly inserted (around 400.000 lines out of 7.000.000).
I don't get any error message.

SQL Server180  
 
 
Anith





PostPosted: Fri Jan 14 09:27:20 CST 2005 Top

SQL Server Developer >> Insertion problem in a multi server environment How are you doing the "inserts"? Do you use 3 part naming & use t-SQL
statements? Do you use any utilities like DTS or any third party tools? Or
BCP IN or Bulk Insert?

--
Anith


 
 
Yohann





PostPosted: Fri Jan 14 10:31:04 CST 2005 Top

SQL Server Developer >> Insertion problem in a multi server environment I use a DTS that calls a first procedure. In this procedure i carry out some
tests. Depending on those tests i launch a second procedure that is on the
second server.
That's this second procedure that is used to carry out the insert. The
insert is that kind :

INSERT INTO MY_DESTINATION_TABLE (<column_list>)
SELECT
<column_list>


I use many insert like this one whith different WHERE conditions.
In my environment with one server, everything is ok.
In the environmnet with two servers, it seems that some of the INSERT are
not executed.

I am not very familiar with SQL server and there may be other ways to
process mass insert. I read somethnig about bulk insert but i thought it was
to load data from files.

yohann



> How are you doing the "inserts"? Do you use 3 part naming & use t-SQL
> statements? Do you use any utilities like DTS or any third party tools? Or
> BCP IN or Bulk Insert?
>
> --
> Anith
>
>
>
 
 
Anith





PostPosted: Fri Jan 14 11:41:11 CST 2005 Top

SQL Server Developer >> Insertion problem in a multi server environment It might be silly, but do you have a ROWCOUNT set on your source server or
destination server?

--
Anith


 
 
Yohann





PostPosted: Thu Jan 20 03:27:01 CST 2005 Top

SQL Server Developer >> Insertion problem in a multi server environment I finally solved my problem by loading my data an other way.

However i saw a parameter in SQL server to configure a timeout for Remote
Procedure Call. It seemed the value indicated in this parameter was
corresponding to the time my procedure was running before being interrupted.
I changed this paramter but it had no effect.

Yohann

"Anith Sen" a écrit :

> It might be silly, but do you have a ROWCOUNT set on your source server or
> destination server?
>
> --
> Anith
>
>
>