Create a script without table but with store proc, view ,etc

nbaubantnbaubant Posts: 3
edited September 19, 2006 12:02PM in SQL Packager Previous Versions
Hi,

I want to create a script for all the strore proc and ther dependances, but i don't want table's dependances. I also want store proc, view, and functions dependances.
Where can i do that?

PS: Sorry for my english, i'm french ans is not very perfect.

Think
Nadege BAUBANT
Consultant Informatique

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    SQL Packager allows you to choose which objects you want to include in the package, but unfortunately the 'include dependent objects' option turns all dependencies either on or off. So if you include stored procedures and you do not want their dependencies included, but include some views as well, and want the dependencies included, then you would need to turn 'include dependent objects' off and manually select the objects that you want to include, and also manually select the dependencies of those objects.
  • Hi,

    Thank you for your response but me does not want to do it manually.
    I seek a tool which do it automatically because we have 1118 procedure, 64 sights, 117 functions. The purpose is to install servers who also have all the tables but not the procedures, the view and the functions.

    Thank you for your help
    Nadege BAUBANT
    Consultant Informatique
Sign In or Register to comment.