Bulk Copy Question

Hi Everyone,
I'm trying to bulk copy the syslogins to a text file. I'm using the command
below in QA and it's giving me the following message when I run the script:
Server: Msg 179, Level 15, State 1, Line 1
Cannot use the OUTPUT option when passing a constant to a stored procedure.
The command I'm using is the below:
bcp syslogins out Logins.txt -N -U"sa" -P"pearapple"
thanks in advance
LarryIf I remember right the table name needs to be qualified by the owner, so
try:
bcp dbo.syslogins out Logins.txt -N -U"sa" -P"pearapple"
Mike John
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:34EF153B-A1C9-4B8E-97F2-ECAFE8773E77@.microsoft.com...
> Hi Everyone,
> I'm trying to bulk copy the syslogins to a text file. I'm using the
> command
> below in QA and it's giving me the following message when I run the
> script:
> Server: Msg 179, Level 15, State 1, Line 1
> Cannot use the OUTPUT option when passing a constant to a stored
> procedure.
> The command I'm using is the below:
> bcp syslogins out Logins.txt -N -U"sa" -P"pearapple"
> thanks in advance
> Larry|||You could try sysxlogins (syslogins is a view). However, you should really use sp_help_revlogins
(search KB for it).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:34EF153B-A1C9-4B8E-97F2-ECAFE8773E77@.microsoft.com...
> Hi Everyone,
> I'm trying to bulk copy the syslogins to a text file. I'm using the command
> below in QA and it's giving me the following message when I run the script:
> Server: Msg 179, Level 15, State 1, Line 1
> Cannot use the OUTPUT option when passing a constant to a stored procedure.
> The command I'm using is the below:
> bcp syslogins out Logins.txt -N -U"sa" -P"pearapple"
> thanks in advance
> Larry|||try
exec master..xp_cmdshell 'bcp syslogins out Logins.txt -N -U"sa"
-P"pearapple"'
bcp is a command line utility.
"Larry" wrote:
> Hi Everyone,
> I'm trying to bulk copy the syslogins to a text file. I'm using the command
> below in QA and it's giving me the following message when I run the script:
> Server: Msg 179, Level 15, State 1, Line 1
> Cannot use the OUTPUT option when passing a constant to a stored procedure.
> The command I'm using is the below:
> bcp syslogins out Logins.txt -N -U"sa" -P"pearapple"
> thanks in advance
> Larry