thank...

very easy....

Hi, you write:

If you want to go down this road....

If there is onother solution ..... o better road.....tell me....

In the case I carry on my initial road ...what are...

Solved with applying SP4

OK, I know that, as you write, the connection will be made under the context of the user that the service is running, but if I would like to force...

I created a windows service which fires the store proc at specified time.

At the moment the connection is made with integrated secuity to avoid security problem.

There is a way to...

Three DBs are involved in transferring process:

source db, temp db and destination db. Tempdb is used to make insert and update because of constraints between tables.

Insert and update are under...

the sp move datafrom a database to another including +/- 500 tables and...too much records.

SQLServer 2000 has the autoshrink option; I have never used, but if Microsoft provides this tool means that...

OK,

but when log file increase about 4 - 5 GB every time the store proc run (especially tempdb), the space on harddisk is not infinite.

How can I do?

thank

I use sp_execsql because some parameters are integer and with comma (,) between paramters they are misunderstood from t-sql.

I have declared also other parameters but the result is the same...

any help will be very appreciated...

the problem is that the store proc will be shipped to several server that they are managed by others admins and belong to differnt companies, so I thought to shrink...

I have declared also other parameters but the result is the same...

any help will be very appreciated...

interesting both solution, I' ll try both

thank

number:

like:

1123156932

thank

thank very mauch...

Besides I have found tables that have time expressed with 10 numbers:

how can convert to and vice-versa

Thank