How can we help you today? How can we help you today?

SQL Prompt throws error when trying to use intellisense

Preparation:

USE master
GO

CREATE DATABASE test_sqlpromt_bug;
GO
USE test_sqlpromt_bug
GO
CREATE TABLE dbo.test (
a int
)
CREATE UNIQUE NONCLUSTERED INDEX [idx] ON [dbo].test (a) ON [PRIMARY]
GO

CREATE DATABASE test_sqlpromt_bug2;
GO
USE test_sqlpromt_bug2
GO
CREATE SYNONYM dbo.test FOR test_sqlpromt_bug.dbo.test;
GO

Now open new SSMS window and copy/paste following code (without $CURSOR$):
CREATE SYNONYM [dbo].[test]
FOR [test_sqlpromt_bug].[dbo].[test];

-- Base object creation script
CREATE TABLE [dbo].[test]
(
[a] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [idx] ON [dbo].[test] ([a]) ON [PRIMARY]
GO


SELECT * FROM test$CURSOR$
Now put your cursor in place of $CURSOR$ variable (delete $CURSOR$ variable as well) and hit ctrl+ space. SQL Prompt crashes







sdks
0

Comments

2 comments

Sort by
  • sdks
    I have no idea why code formatting is not working in my post. It looks good while I am editing
    sdks
    0
  • RichardL
    Hi @sdks

    Thanks for your post. 

    If you don't get an answer from the community you can always send us a ticket so that an engineer can look in to this for you if you have a support contract. 

    Best

    Richard Lynch. 
    RichardL
    0

Add comment

Please sign in to leave a comment.