Export to text file

Is there any built in functions in sql server that allow you to export data
from sql server to a flat file without using xp_cmdshell?
I would like to do this through an application where the user login wouldn't
need symin rights and have the sql server actually create the file simila
r
to calling bcp through xp_cmdshell.
ThanksWrap it in a Stored Procedure, giving the user EXECUTE rights on the stored
procedure. Set up the proxy account.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"John" <John@.discussions.microsoft.com> wrote in message
news:474BA5A0-7AA3-4393-ABE0-02F72079E4AE@.microsoft.com...
> Is there any built in functions in sql server that allow you to export
> data
> from sql server to a flat file without using xp_cmdshell?
> I would like to do this through an application where the user login
> wouldn't
> need symin rights and have the sql server actually create the file
> similar
> to calling bcp through xp_cmdshell.
> Thanks|||Thanks. I kind of figured something like that. I'm actually having a
problem with the constant syntax though.
Arnie Rowland wrote:
> Wrap it in a Stored Procedure, giving the user EXECUTE rights on the store
d
> procedure. Set up the proxy account.
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:474BA5A0-7AA3-4393-ABE0-02F72079E4AE@.microsoft.com...|||I think declaring a variable and setting its value is the way I need to
go(?), but I don't want to insert or replace any values in the table. I
want to take information that isn't in the table (the account number)
and append it to the beginning of what gets pulled from the table. I'm
about how and where to make it happen in SQL 2000.
birdbyte@.gmail.com wrote:
> Thanks. I kind of figured something like that. I'm actually having a
> problem with the constant syntax though.
> Arnie Rowland wrote: