What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt throws error when trying to use intellisense

sdkssdks Posts: 44 Bronze 2
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







Tagged:

Answers

Sign In or Register to comment.