Generate Database Script: Script Behavior missing option

• dba_user

  Default port

  Points: 1458

  More actions

  May 10, 2006 at 12:06 pm

  #168922

  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!

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  May 15, 2006 at 9:55 am

  #637900

  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