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

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

Dave_JacksonDave_Jackson Posts: 4 New member
edited November 30, 2017 2:53PM in SQL Prompt
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
Tagged:

Answers

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.