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

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

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
Dave_Jackson
0

Comments

1 comment

Sort by
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.