Microsoft KB Archive/266162

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

Article ID: 266162

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft Windows 2000 Standard Edition

-



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 &quot;0x6b741868&quot; referenced memory at &quot;0x03290090&quot;. The memory could not be &quot;read&quot;.

Click on OK to terminate the program.

NOTE: The actual memory address may vary.



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.



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



Steps to Reproduce Behavior

 * 1) Start Visual InterDev 6.0. If the New Project dialog box does appear automatically, from the File menu, click New Project.
 * 2) 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.
 * 3) In the dialog box that appears, set up a data link to a Microsoft SQL Server database.
 * 4) In the Project Explorer window, expand the project. Once the project is expanded, you can see all of the available connection objects.
 * 5) Right-click the connection object, and then click Add SQL Script from the pop-up menu.
 * 6) Choose Table Script.
 * 7) Set up a script to create a table.
 * 8) Save the project.
 * 9) 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.

Keywords: kbbug kbdatabase kberrmsg kbide kbpending KB266162

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.