i did not yet created the new services accounts in the new domains. That s why i ask for the steps to perform this.

Both, sql and windows authentication. Waht about th system accounts?

Hello All,

we could resolved the problem separating the select from insert /update instructions. But it s strange that we didnt had this problem before. And the number of row did not increase. 

Scott,

how should i commit the insert every few thousands rows? 

Hello Sameer,

thank you for your help. It works now.

i never used OPENROWSET. Can i add it to my proc?

Hello Ryan,

exactly this.

hello,

indeed it s not really what i need. I extract data from a TrackIT DB to an xls file. And i need in the xls file the date when the...

i got it!

thanks

thanks for the answer Alzdba but one question what do you mean with: load your data in clustering index order and how to do it?

dexter, it s indeed one transaction. Your suggestion to backup and shrink doesnt help so much the we want to avoid the transaction log growth before the 95 Gb.

But what will happen...

I have checked bkelley says, the public role has exec permissions on the sp.

Strange is that on the dev sql server, the same user can see the processes. But not...

Greg,

after connecting to the network, the DTS take a text file and insert into the Database. And then there is following Task where it 's stucks:

SELECT     dbo.Tb_Temp_Pere.Marche, dbo.Tb_Temp_Pere.CodeBarre,

dbo.Tb_Temp_Pere.Titre, dbo.Tb_Temp_Pere.Auteur,...

thank tyou, it works and it was so easy. I am ashame.

thank you.

I already search over the net but i could not find anything