Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who to Export a Batch of SP to an other BD
Message
 
To
27/12/2002 17:08:33
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00736185
Message ID:
00736223
Views:
10
Thank's a lot it's work fine

Rock


>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
Reply
Map
View

Click here to load this message in the networking platform