Ctrl + B, Ctrl + i to exec an inline statement on an object not in dbo schema
Dave_Jackson
Posts: 4 New member
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
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com