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

nbaubant

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

Brian Donahue

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.

nbaubant

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