Re: SQL Question

["Jeff Day" <Jeff.Day@xxxxxxxx>]

from the production box, within strsql for example, you can use the
command "Connect to".  include the dev box, username, and password, and
you will connect to the other machine.  

> > > Alan Shore <AlanShore@xxxxxxxx> 12/20/2006 10:57:24 AM >>>


Good morning list - Before I forget, or don't have a chance again,
A Merry Christmas and a Happy New Year to one and all.

We have 2 boxes, one for PRODUCTION, the other one for DEVELOPMENT
Each weekend, using DDM, we refresh the DEVELOPMENT data from the
PRODUCTION box.
The past 3 weekends we have been having problems where one of the files
has
not finished till late Monday/early Tuesday. This has resulted in a
cleanup
of this file deleting some records that shouldn't be there otherwise
we
have problems on the DEVELOPMENT box when we try and test any new
changes
to the ORDER ENTRY system.
My question is
can SQL be used to directly create files ON the DEVELOPMENT box from
the
same name files ON the PRODUCTION box?
If so, does anyone have any examples of what is required?


Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx