You should use a method described in another topic: make a table where your users want to run the dts and make a job which permanently monitors this table and...

Hi Dan,

Firstly, check if your linked server is functional. You should check your dcom rights because your sql server instances are on different stations. If you logon on stations with...

Also, for proper functionality of linked server, you should have DCOM rights available between the 2 stations where SQL Server instances reside.

So you will come to my solution !

I think it's pretty easy!

Hi,

You can disable first all FK (constraints) and after you populate with respect to constraints, your tables, you should enable them. Here is the code:

SET QUOTED_IDENTIFIER OFF

So, there is no solution for my problem. My system is under heavy load, even night. Maybe, a warm change of hard-disk with a new one. And this time of...

Thanks for advices!

Anyway, there would be SQL Server shut down? I ask that because my application should run continously, without pauses !! My application is almost a real-time application.

you should script it as stored procedure which would be run as daily job. Maybe in this script you should be aware about all constraints, how to drop them and...

This is a good thing! Is there a setting in SQL 2005 to do that or is done automatically?

i think BCP is the speedest method of all.

Thanks for your reply!

So, if i set dynamically memory from min to max, let say, max=1,4 GB from a total memory RAM of 2 GB, I should expect from SQL...

What recovery model have you selected for your database? You should have Simple.

I forgot to say: I have a database with 30 tables with, about 2,500,000 records, each. After the 30th day the oldest table is deleted. A new table is created...

Hi,

I've made another test: I've changed the fill-factor of reindexing the tables from 0 to 90 %. I've noticed a good change. Memory is still increasing but, so far, very...