xpsql.cpp: Error 87 from GetProxyAccount on line 604

From: S (vadlamanis_at_gmail.com)
Date: 04/18/05

  • Next message: Sue Hoegemeier: "Re: xpsql.cpp: Error 87 from GetProxyAccount on line 604" 
    Date: 18 Apr 2005 12:31:08 -0700

    Hi,
       I am trying to execute a stored proc from ASP. The contents of
    stored Proc:

    DECLARE @cmd nvarchar(500)
    SET @cmd = 'bcp DBNAME.dbo.TABLENAME out
    D:\Inetpub\ftproot\TABLETXT.txt -k -c -E -USQLUSER -PPASSWORD'
    EXEC master..xp_cmdshell @cmd
    GO

    I am a webdeveloper, I don't know what to do?
    Any help would greatly be appreciated.

  • Next message: Sue Hoegemeier: "Re: xpsql.cpp: Error 87 from GetProxyAccount on line 604"

    Relevant Pages

    • Re: full-text contains * issue
      ... You may also want to consider using a stored proc for this situation as it ... EXEC usp_FTSearchPubsInfo '' ... > no data but was concatenation of the fields I wanted to index. ... > This is the SQL ...
      (microsoft.public.sqlserver.fulltext)
    • Re: T-SQL how to deal with results from stored proc
      ... > My attempt was to use INSERT EXEC to fetch te results of several ... In a wrapping stored proc I intended to collect data ... You can also use temp tables, as I discuss in the article I pointed you to. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
      (comp.databases.ms-sqlserver)
    • XML Update Question
      ... I am having trouble updating a row that has a string value for a bit column. ... Below I have given my table def, stored proc and sample data. ... EXEC sp_xml_preparedocument @hDoc OUTPUT, @XMLEmp ...
      (microsoft.public.sqlserver.programming)
    • Re: Temp Tables, Transaction and Loops
      ... Is it performant and what is the reason for using EXEC sp_executesql in this ... > CREATE PROC spmyproc ... > ALTER TABLE #Temp ADD col INT ... >> procedure from another stored proc within a loop and a transaction I ...
      (microsoft.public.sqlserver.programming)
    • RE: An insert exec statement cannot be nested. Pls HELP.
      ... Before we can use SELECT * FROM OPENQUERY(LOCALSERVER, 'EXEC SP....'), ... Do we put these 3 lines in the stored proc that is running the SELECT ... Or do we just execute the 3 lines manually in query ... server LOCALSERVER? ...
      (microsoft.public.sqlserver.programming)