Generate Database Script: Script Behavior missing option

  • I am going to generate a script to move objects from my test to production SQL Servers.  I right click on the database and go to task and select Generate Scripts.  In the Script Options for Objects - in the Script Behavior option- there should be 3 options:

    1. Drop statements

    2. CREATE statements

    3. Drop followed by CREATE statements.

     

    All I get are the first 2 options but I really need the 3rd option.  Why would this be missing?  Thanks!

  • This was removed by the editor as SPAM

  • In the books online it is mentioned about the three options however I too did not find the third option on my installation, wondering if we it is any configuration issue.

    Prasad Bhogadi
    www.inforaise.com

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

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