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

procedure name completion with parms after GRANT

moffmoff Posts: 34
edited August 2, 2007 11:20AM in SQL Prompt Previous Versions
when typing
GRANT EXECUTE ON uspMyStoredProc
and using sql prompt to complete the sproc name, I get
GRANT EXECUTE ON uspMyStoredProc
	@Parm1 = ?, -- int
	@Parm2 = ? -- varchar
whereas actually in the context of GRANT rather than EXEC the parms shouldn't be included in the auto completion.

could this be included in a future release?

thanks, robin.

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Robin,


    Oops, I'll try to get that fixed for the next release. Thanks for letting us know.


    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.