January 17, 2019 at 1:26 pm
January 17, 2019 at 1:43 pm
Go back and ask said DBA why he wants this. Sounds absurd. The nice thing about stored procedures is that you can assign rights to them. you can't do that to ad hoc SQL as far as I know.
January 17, 2019 at 2:07 pm
Does the reportcurrently use the stored proc or is this a new report? I ask because, if youhave a report that starts with a stored proc but is changed to ad-hoc (inline)SQL - the parameters should not disappear in SSRS. Either way - you can manually add theparameters.
Other things you can try:
Both of these ^^have worked for me
-- Itzik Ben-Gan 2001
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply