打开设计查询编辑器时SSMS崩溃 [英] SSMS crashes when opening Design Query Editor

问题描述

当您尝试使用sql语句在 USE数据库之前打开设计查询编辑器时，SQL Server 2005 Management Studio中的崩溃修复程序; ？

is there a fix for the crash in SQL-Server 2005 Management Studio when you try to open a design-query-editor with a sql-statementent preceding USE database;?

例如：

USE DB1;
SELECT * FROM Table1;

如果您标记 SELECT * FROM Table1; ，可以成功打开编辑器。
如果您标记两行，SSMS将崩溃与Microsoft SQL Server Management Studio已停止工作-Dialog（选项调试或关闭SSMS）和一些关于此问题的额外信息fe：

If you mark SELECT * FROM Table1;, you can open the editor succesfully. If you mark both lines, SSMS will crash with a "Microsoft SQL Server Management Studio has stopped working"-Dialog(with the option to debug or close SSMS) and some additional information on this problem f.e.:

  Problem signature:
  Problem Event Name:   BEX
  Application Name: SqlWb.exe
  Application Version:  2005.90.5000.0
  Application Timestamp:    4d02772b
  Fault Module Name:    vdt80.dll
  Fault Module Version: 8.0.50727.1826
  Fault Module Timestamp:   480d6e41
  Exception Offset: 0032ae42
  Exception Code:   c0000409
  Exception Data:   00000000
  OS Version:   6.1.7601.2.1.0.16.7

SQL-Server 版本：

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
9.00.5000.00       SP4       Enterprise Edition (64-bit)

操作系统：

Windows Server 2008 R2 Standard(SP 1)

编辑：如果我尝试打开设计器与T-SQL语句如：

Edit: this problem also occurs if i try to open the designer with T-SQL Statement like:

IF EXISTS(
    SELECT *
    FROM ClosingDate
    WHERE DATEDIFF(DAY, DATEADD(DAY, -1, GETDATE()). ClosingDate) = 0
) UPDATE Table2 SET
    Column1 = 255
WHERE
    Column1 = 1

推荐答案

确保，使用db语句并将代码更改为：

sure, take out the use db statement and change the code to this:

select * from DB1.dbo.Table1

您可以从其他不在上下文中的服务器上的其他数据库中选择数据。

this syntax will allow you to select data from other databases on the same server in which you are not in the context of.

这篇关于打开设计查询编辑器时SSMS崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！