Transfering Stored Procedures?

[Infinitation]

I finally was able to upload my SQL database to the servers. Once I run my site though, not a whole lot worked. I looked to see what all had transfered. After requesting DBO, I tried again. I realized that the Stored Procedures, all 30 of them, were not transfering. I need to resolve this issue fairly quickly as this has been tested on other web servers without incidence.

Thanks in advance for any help!

[Brangwyn]

I answered your PM as well, but make sure in the DTS wizard you've got the option selected that shows "all" or shows the SP's as well, they should then appear below the list of tables and you should be able to select them for copying over as well.

[Infinitation]

Got it all working, and thanks for the PM. I had to adjust the ID's of all the tables, but a minor inconvience in the big scheme of things. Thanks for your help!

[Brangwyn]

Super Duper