Ex. I have a procedure with a select: "Selct A, B, C, D From E". Now when i know the name of that procedure, I want to know what fields in that procedure in system table or sth like that. How can i do that? Please help me!
One way you can see the parameters that a stored procedures uses is with query analyzer. Use the object browser and expand the database to stored procedures. Click on the stored procedure and expand parameters. It will list the parameter and datatypes.