Reverse Engineering

[Analyst51]

Question,
Is it possible to reverse engineer an SQL server stored procedure executable without the source code or access to the original development environment? My attempt is to use UML notation and class modeling to document functional requirements while discovering user stories, scenarios, and test cases to V&V. if this is possible, please provide some help in getting started!
Thank you in advance

[pvickers]

No - As far as I know, you require access to the stored procedure source code from the SQL Server system catalog to accomplish this.

Regards,
Perry

[Analyst51]

Thank you for the quick response, I will obtain the source code and continue this conversation next week.

Is the stored procedure API source code the only code needed?

[pvickers]

The stored procedure source code will reference other database related "objects" such as tables and views.  You will likely want to be able to view these definitions also.
This generally involves having additional privileges such as the ability to query the "INFORMATION_SCHEMA" or possibly have the "VIEW ANY DEFINITION"  permission.

I suggest you talk to your DBA for advice on the exact privileges you require because it is a more complicated topic.

For example, if the source system is a proprietary application you may require legal permission from your vendor before your DBA can provide you with the database privileges.

Regards,
Perry