Post reply

How to get entire database objects statements(queries)....:(

  • April 6, 2012 at 1:32 am

    #149931

    Hey friends,

    I am having one database named HR_DB126 in which multiple objects are present, I want the statements(queries) of all that objects how it is possible to get that statements.....?

    I would like to save it in MS WORD DOC for future understanding, how it is possible......?

    Thanks & Regards,

    Er.karthikn

  • April 6, 2012 at 2:56 am

    #1469979

    In SSMS right click on the database and script database as. You then just need to select the objects you would like to include in the generated script.

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • April 6, 2012 at 4:58 am

    #1470026

    also, save the script as a txt / sql file, not a word doc; depending on your settings for autocorrect, some words could get changed from the actual script in Word, and that's a pain.

    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 3 posts - 1 through 2 (of 2 total)

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