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?
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
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);
}
};
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.