[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Fatal Exception on SQL Server Project Deploy

Posted on 2009-04-17
1
Medium Priority
?
531 Views
Last Modified: 2013-12-17
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

0
Comment
Question by:johnalphaone
1 Comment
 

Accepted Solution

by:
johnalphaone earned 0 total points
ID: 24166690
Ok, I've resolved this now.  The problem went away when I put Data Execution Prevention back to the minimum setting.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Loops Section Overview

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question