BUG: Devenv.exe Exception When Running SQL Scripts in Database Projects

View products that this article applies to.

This article was previously published under Q266162

SYMPTOMS

If you execute the same SQL script multiple times from the Project Explorer window of a Visual InterDev database project, the following error may occur:

DEVENV.EXE - Application Error
The instruction at "0x6b741868" referenced memory at "0x03290090". The memory could not be "read".

Click on OK to terminate the program.

NOTE: The actual memory address may vary.

Back to the top

RESOLUTION

To work around the problem, create a stored procedure that performs the same functionality as the SQL script. Then add code in the SQL script that calls the stored procedure.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Start Visual InterDev 6.0. If the New Project dialog box does appear automatically, from the File menu, click New Project.
In the New Project dialog box, expand the Visual Studio folder in the left pane. Select the Database Projects folder in the left pane. In the right pane, click New Database Project. Type a name for your project in the Name text box, and then click Open.
In the dialog box that appears, set up a data link to a Microsoft SQL Server database.
In the Project Explorer window, expand the project. Once the project is expanded, you can see all of the available connection objects.
Right-click the connection object, and then click Add SQL Script from the pop-up menu.
Choose Table Script.
Set up a script to create a table.
Save the project.
Execute the script multiple times by repeatedly right-clicking and clicking Execute. You might have to execute it up to 50 times before the Devenv.exe exception occurs.