SQL Prompt throws error when trying to use intellisense

sdks

Preparation:

<div>USE master</div><div>GO</div><div><br></div><div>CREATE DATABASE test_sqlpromt_bug;</div><div>GO</div><div>USE test_sqlpromt_bug</div><div>GO</div><div>CREATE TABLE dbo.test (</div><div>a int</div><div>)</div><div>CREATE UNIQUE NONCLUSTERED INDEX [idx] ON [dbo].test (a) ON [PRIMARY]</div><div>GO</div><div><br></div><div>CREATE DATABASE test_sqlpromt_bug2;</div><div>GO</div><div>USE test_sqlpromt_bug2</div><div>GO</div><div>CREATE SYNONYM dbo.test FOR test_sqlpromt_bug.dbo.test;</div><div>GO</div>

Now open new SSMS window and copy/paste following code (without $CURSOR$):

<div>CREATE SYNONYM [dbo].[test]</div><div>FOR [test_sqlpromt_bug].[dbo].[test];</div><div><br></div><div>-- Base object creation script</div><div>CREATE TABLE [dbo].[test]</div><div>(</div><div>[a] [int] NULL</div><div>) ON [PRIMARY]</div><div>GO</div><div>CREATE UNIQUE NONCLUSTERED INDEX [idx] ON [dbo].[test] ([a]) ON [PRIMARY]</div><div>GO</div><div><br></div><div><br></div><div>SELECT * FROM test$CURSOR$</div>

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

sdks

I have no idea why code formatting is not working in my post. It looks good while I am editing

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.