question

brawrajab-6056 avatar image
0 Votes"
brawrajab-6056 asked brawrajab-6056 commented

How to see the code for stored procedures in sql server report builder

how can i see the code for a stored procedure in sql server report builder 3?

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered brawrajab-6056 commented

how can i see the code for a stored procedure in sql server report builder 3?

Report Builder is tool to create reports, it can not show you the source code of a stored procedure, it can onyl consume the result of a SP.
Use SSMS to script out the source code of the SP => Script stored procedures


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you @OlafHelper-2800 I understand

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @brawrajab-6056 ,

View stored procedure code can only be in SSMS.
Right click on the stored procedure and select Script Stored Procedure as | CREATE To | New Query Editor Window / Clipboard / File.

You can also do Modify when you right click on the stored procedure.

For multiple procedures at once, click on the Stored Procedures folder, hit F7 to open the Object Explorer Details pane, hold Ctrl and click to select all the ones that you want, and then right click and select Script Stored Procedure as | CREATE To.
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.