How to reverse-engineer SQL statements issued by a legacy application
You can setup a test database and trace the application activity using the SQL Server profiler. By tracing the event "Security Audit\Audit Schema Object Access Event" you can effectively trace all the SQL the client is sending to the server.  But that will not necessarily help you in discover the application logic.