Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who to Export a Batch of SP to an other BD
Message
From
27/12/2002 17:08:33
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00736185
Message ID:
00736195
Views:
9
This message has been marked as the solution to the initial question of the thread.
You can also script them in the Enterprise Manager, usually the generated script will create them in the correct order. If not, you can open up the script and put the creation of some sp's in the required order.

Just right click the db and select all tasks, sql script and select only stored procedures and udfs. After you create the script open up the script in the Query Analyzer and execute it.

HTH

>Hi Guys,
>
>I try to Export all my SP & UDF to an other DataBase. I Try with a DTS batch but i have integrity problem some SP need to be create before other one.
>
>Do you have an Idea to Skip the Integrity check ?
>
>Rock
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform