Ctrl + B, Ctrl + i to exec an inline statement on an object not in dbo schema

Dave_Jackson

If I press Ctrl + B, Ctrl + I after a line like

Exec mySchema.usp_MyProc

SQL prompt no longer expands the SP to an inline script

It still works when the Object is in the schema dbo

bizarrely if you reference an object in dbo in the same session, such as

EXEC dbo.uspSelectEmployeeHours @FromDate = '2017-11-30', -- date
@ToDate = '2017-11-31' -- date

it works! For clarity for the one in mySchema!

I'm using version 9.0.0.3116

Eddie D

Hi, thank you for your forum post.

Took me longer than I expected to reproduce, as soon as I click space bar after typing:
Exec mySchema.usp_MyProc
SQL Prompt automatically added the inline statement for me to enter a values for the variable.

After closing the pop-ups, like you found that CTRL + B, CTRL + I not to be working. I have submitted a Bug Report whose reference is SP-6756.

Hopefully my colleagues in the development team will be able to provide a fix for the problem. Thank you for bringing it to our attention.

Many Thanks
Eddie