When using SQL Service broker is used with Stored Procedures you need to make sure the service instance user has the view definition permission on DB so that Stored procedures and views are loaded with proper Schema.
If not then following thing will happen.
your Stored Procedure parameters will always show as Required ( even if you have provided default value.)
Thanks
No comments:
Post a Comment