Create Script with dependent objects SQL Server 2005

• Rohan Wali

  Grasshopper

  Points: 19

  More actions

  May 12, 2007 at 7:56 pm

  #124050

   Hi,

  I need to script a view but with dependent objects. The view has a lot of user defined functions and manually creating the script is a pain.

  There is a way to do it in SQL Server (2000) Enterprise manager where one right clicks the view --> All Tasks --> Generate Script and then Check

  "Generate Scripts for all dependent objects" in the Formatting tab.

  The db i am using is on SQL Server 2005.

  Is there a equivalent way to do this in SQL Server 2005 Management Studio ?

   

   

  regards,

  Rohan Wali

  ---

  Regards,

  Rohan Wali

  wali.rohan@gmail.com.(nospam).
  

• Neil Griffiths-347703

  SSC Journeyman

  Points: 89

  More actions

  May 14, 2007 at 3:17 am

  #706147

  Yep,

  Right click on the database click, tasks->generate script, on the choose script options change "Generate Script for Dependant Objects".

   

  Regards

  Neil