removing blank spaces from output file

Is there a way to remove blank space padding from around
my result set sent to a text file using osql. I can only
seem to find a column_width setting. I am using the below
and am after a csv file without blank padding.
osql -S(local) -Uuser -Ppassword -s, -h-1 -w254 -
Q"DMSWEB.dbo.rf_test 200035" -oc:\TestReport3.txt
Thanks in advance.
Amelia
Hi,
Consider BCP with QUERYOUT option to do this.
Sample
bcp "exec DMSWEB.dbo.rf_test 200035" queryout
c:\TestReport3.txt -c -S(local) -Uuser -Ppassword
Thanks
Hari
MCDBA
"Amelai" <anonymous@.discussions.microsoft.com> wrote in message
news:2352201c45e43$427d3c60$a501280a@.phx.gbl...
> Is there a way to remove blank space padding from around
> my result set sent to a text file using osql. I can only
> seem to find a column_width setting. I am using the below
> and am after a csv file without blank padding.
> osql -S(local) -Uuser -Ppassword -s, -h-1 -w254 -
> Q"DMSWEB.dbo.rf_test 200035" -oc:\TestReport3.txt
> Thanks in advance.
> Amelia
|||Thanks heaps for your help Hari. Much appreciated.
:0)
Amelia

>--Original Message--
>Hi,
>Consider BCP with QUERYOUT option to do this.
>Sample
>bcp "exec DMSWEB.dbo.rf_test 200035" queryout
>c:\TestReport3.txt -c -S(local) -Uuser -Ppassword
>--
>Thanks
>Hari
>MCDBA
>"Amelai" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2352201c45e43$427d3c60$a501280a@.phx.gbl...
below
>
>.
>

removing alternate snapshot location setting

I was using an "alternate snapshot
location" for the storage of my reinitilized
snapshot data. All those snap shots have
made it to the subscribers. I am now
wanting to go back to those pacakges and set
their snapshot location back to default
(basically the default dir on the
distributor). When I go back and check that
check box, it's not going to try to start a
new snapshot is it?
I figured once the snapshot was done and
pushed over, that the rest of replication
would be the sync'ing part.
Thanks,
-comb
No - this doesn't cause the snapshot agent to start automatically, or mark
the subscribers for reinitialization.
It only affects things the next time you choose to run the snapshot agent.
Regards,
Paul Ibison
|||In article <OPxX59qfEHA.556
@.tk2msftngp13.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> No - this doesn't cause the snapshot agent to start automatically, or mark
> the subscribers for reinitialization.
> It only affects things the next time you choose to run the snapshot agent.
> Regards,
> Paul Ibison
>
>
that is perfect then.. thats the information
i needed to know..
thanks for the response..
-comb