Problem report xp_MSADEnabled

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Marco Broenink (marco.broenink_at_ict.nl)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 05:11:02 -0700

Hello,

I have detected a problem with the stored procedure xp_MSADEnabled. I am using Windows 2000 (workstation, 5.00.2195, SP4) and SQLServer 2000 Developer (Product version 8.00.858 SP3). Calling xp_MSADEnabled results in an unspecified error (-2147467259).

If I call the same procedure on a Windows 2003 Server machine, it works fine.

This procedure is called in several other system procedures like sp_addmergepublication and sp_dropmergepublication.

I am developing the replication functionality of a database application. I discovered the problem when I wanted to call sp_addmergepublication from my ADO.NET application. This resulted in the SqlException "A severe error occurred on the current command. The results, if any, should be discarded". Calling this procedure from the SQL Query Analyzer did not result in the error.

greeting, Marco

Relevant Pages

  • Problem report xp_MSADEnabled
    ... If I call the same procedure on a Windows 2003 Server machine, ... This procedure is called in several other system procedures like sp_addmergepublication and sp_dropmergepublication. ... greeting, Marco ...
    (microsoft.public.sqlserver.replication)
  • Re: Security and Content Update Problems with IEAK6 SP1
    ... Security and Content settings of that 2003 Server Machine. ... The registry keys for Windows Server 2003 are different then Windows 2000 ... It downloads find and install ... "Robert Aldwinckle" wrote: ...
    (microsoft.public.windows.inetexplorer.ie6.ieak)
  • Windows 2003 - The domain users are not being listed when trying to share folders
    ... I'm running a windows 2003 server machine that's connected to a windows 2003 ... including the windows 2003 SBS domain server. ... the domain users are not being listed and I'm unable to add the ...
    (microsoft.public.windows.server.dns)
  • Re: service groups
    ... Dave Patrick ....Please no email replies - reply in newsgroup. ... Microsoft MVP [Windows] ... | 2000 server machine. ... | manipulate service groups to open in a certain order. ...
    (microsoft.public.windows.server.general)
  • Re: Cannot run the FrontPage Server Extensions on this page
    ... To find the best Newsgroup for FrontPage support see: ... | Hello Stefan, ... This code worked on Windows 2000 ... | to the Windows 2003 Server machine. ...
    (microsoft.public.frontpage.extensions.windowsnt)