Copying Stored Procedures

Results 1 to 3 of 3

Thread: Copying Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default Copying Stored Procedures

    Hello-<BR><BR>Is there a quick way (besides DTS wizard) to copy stored procedures from one databse to another in Enterprise Manager? For some reason the DTS wizard only seems to work for tables, and the only other thing I seem to be able to do is to cut and paste each stored procedure by hand (what a pain).<BR><BR>Any help would be appreciated.<BR><BR>Thanks<BR><BR>KenS

  2. #2
    Join Date
    Dec 1969

    Default RE: Copying Stored Procedures

    Just execute the T-SQL code of the stored proc on the other server. If you need to do a lot at a time, you can highlight them in the list in the enterprise manager, hit copy, and then paste into the query analyzer. Set your connection to the destination server, and hit execute.

  3. #3
    Join Date
    Dec 1969

    Default Transfer Objects.

    Right click on the database and choose All Tasks --&#062; Export...<BR><BR>Then, go through the prompts and when given the choice, choose Transfer Objects.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts