Re: A severe error has occurred - HELP!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mary Chipman [MSFT] (mchip_at_online.microsoft.com)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 10:11:32 -0500

Executing sp_addmergepublication in SQL Server requires membership in
the sysadmin or db_owner roles--does your client app connection string
satisfy these requirements? You don't mention what precisely the
"severe error" message is. Are you connecting to the publisher? Do you
have sufficient permissions? Are you supplying all of the necessary
arguments to the sproc? I'd suggest creating a Profiler trace and also
wrapping some SqlException handling around the call. BTW, the print
statement is specific to QA, not a part of T-SQL, and has no effect in
client code.

--Mary

On Wed, 16 Mar 2005 08:29:09 -0800, Darin <darin_nospam@nospamever>
wrote:

>I have done quite a bit of research on the web and it seems many people
>get this same error, in different circumstances, and noone (including
>Microsoft) seems to have a fix or be able to correct the problem.
>
>My situation is I am writing a VB.NET application and would like the
>user to be able to click on a button and it sets up replication. On the
>command:
>
>exec sp_addmergepublication @publication='SAMPLEmerge'
>
>I receive an error:
>
>A severe error has occurred on the current command. The results, if any,
>should be discarded.
>
>This is command works fine (perfectly) from query analyzer.
>
>I have seen some threads that it says the SP has print commands and
>remove those - this is a SQL supplied SP that has NO print commands
>since query analyzer just returns the command completley successfully.
>
>Does ANYONE have any solution to this problem.
>
>Darin
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!

Relevant Pages