Stored Procedures

  • Is there some documentation that describes what each of the stored procedures do? 

    When opening these up there is no descriptor, other than actually executing the SP how do you know what it is going to do?

    TIA

  • system stored procedures have a lot of notes in Books Online.

    all the other stored procs would be created by your developers or some other party, so it's up to them to include comments in the procedure;

    if you read the actual text of the procs, you could deduce what they are doing, but there's nothing else to go by. you could give yourseelf something to do for a week by adding comments to the stored procs you read the code on, then saving/recompiling them

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply