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

Question

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

Answer 1

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

Answer 2

Hi @braw rajab ,

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.