Link to home
Start Free TrialLog in
Avatar of johnalphaone
johnalphaone

asked on

Fatal Exception on SQL Server Project Deploy

I'm using SQL Server 2005 9.00.4035.00 (Intel X86) and Visual Studio 2008 SP1.  

I need to develop a managed stored procedure and this is just a trivial starting point for something that will become a lot more complex.  However it is failing at the first hurdle.  When I do Deploy Solution I get
"A severe error occurred on the current command.  The results, if any, should be discarded."
in the VS Error List.  

In the SQL Server log I get:
"SqlDumpExceptionHandler: Process 54 generated fatal exception c0000096 EXCEPTION_PRIV_INSTRUCTION. SQL Server is terminating this process."
and then a dump.

Any pointers, please?

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
 
 
public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void TeamChurn() {
        SqlCommand myCommand = new SqlCommand();
        myCommand.CommandText = "SELECT * FROM MCTeams";
        SqlContext.Pipe.ExecuteAndSend(myCommand);
    }
};

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of johnalphaone
johnalphaone

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial