"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:%23akEH2GCGHA.1312@TK2MSFTNGP09.phx.gbl...
> Hello there
>
> I'm working with query anlyser.
>
> Is there a way with code to transfare to another server?
>
>

"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:%23Y2h8LJCGHA.3936@TK2MSFTNGP12.phx.gbl...
> Yes Andrew
>
> It begun from another issue i've asked on DTS aboud the log file.
>
> I dound the property you said about TABLOCK by using sp_tableoption and it
> worked fine: the log file hasen't grow in a bit. Thanks
>
> I could run the store procedure only on the destination object by connect
> it
> by query anlyser
>
> I'm trying to build store procedure that will do all the options. In order
> to do that i must run sp_tableoption on the destination tables on the
> diffrent server. and the store procedure must start from the source server
>
> How can i do that?
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:elQeVHJCGHA.4040@TK2MSFTNGP12.phx.gbl...
>> Roy,
>>
>> Transfer what? Can you please explain in a little more detail what you
> want
>> to accomplish?
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>>
>> "Roy Goldhammer" <roy@hotmail.com> wrote in message
>> news:%23akEH2GCGHA.1312@TK2MSFTNGP09.phx.gbl...
>> > Hello there
>> >
>> > I'm working with query anlyser.
>> >
>> > Is there a way with code to transfare to another server?
>> >
>> >
>>
>>
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:elQeVHJCGHA.4040@TK2MSFTNGP12.phx.gbl...
> Roy,
>
> Transfer what? Can you please explain in a little more detail what you
want
> to accomplish?
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Roy Goldhammer" <roy@hotmail.com> wrote in message
> news:%23akEH2GCGHA.1312@TK2MSFTNGP09.phx.gbl...
> > Hello there
> >
> > I'm working with query anlyser.
> >
> > Is there a way with code to transfare to another server?
> >
> >
>
>