Post reply

Need some help quickly please

  • June 28, 2010 at 12:41 pm

    #234430

    I need help finding out how to get the description information from a view/stored procedure, function etc..

    I need to produce a list of all Views/Stored Procedures/Functions/Tables that were entered into the database pretty quickly. I'm still looking around for some information on how to do this but thought I would as the community.

    Thanks

  • June 28, 2010 at 1:23 pm

    #1185989

    you can certainly veiw all of those in SSMS. as for getting a description you really would have to look at each one and see what it does. some you may be able to determine from the name if it is named logically but most likely you will have to open each one in modify script and see just what it is doing.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 28, 2010 at 2:46 pm

    #1186037

    Stephen crocker (6/28/2010)

    I need help finding out how to get the description information from a view/stored procedure, function etc..

    I need to produce a list of all Views/Stored Procedures/Functions/Tables that were entered into the database pretty quickly. I'm still looking around for some information on how to do this but thought I would as the community.

    Thanks

    SELECT * FROM sys.objects WHERE type <> 'S'

    The above will get you the names. As for descriptions, do any of the objects have extended properties that have an overview? Do any of the items (except for the tables, of course) have code headers with descriptions (almost hurt myself on that one 🙂 )?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 28, 2010 at 2:50 pm

    #1186040

    Perfect, thank you

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

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