Hi,

I`m having real problems trying to upload the stored procedures from my local sql database upto my remote sql database using Microsoft SQL - Enterprise Manager.

Has anyone else had similar problems?

Hi Neil,

Thank you for your post, sorry to hear your having problems.

When you say your having trouble could you please explain a little. Are you receiving any error messages or is the script simply not generating the tables and / or stored proc. Any further information you can provide would be greatly appreciated

Explore our products...
http://demos.instantasp.co.uk/

Hi Ryan,

When I try to export the Stored Procedures it says "Failed to copy objects from Microsoft SQL Server to Microsoft SQL Server".

And then says "User or role 'neil' already exists in the current database."

Hi Neil,

Are you using DTS to export the data to a remote server ? Is it possible you can use the .SQL file to create the tables and stored procs on the remote SQL Server ?

I'm assuming your using the DTS tool because you have data locally which you would like to carry over. You could be receiving this error for a number of reasons. You mention that the its only the stored procs your having problems with. If your tables have copied over then i would suggest creating the stored procedures using a tsql script. I would be more than happy to supply a .sql script you can use which will not add or modify any tables but just create the stored procs if you wish.

If you would still like to use DTS please ensure you are selecting "copy database objects between sql servers" and not "copy tables, views and data". You see iden****ies, defaults, primary keys etc are all objects and relate to the table.

I also found a very interesting article you may wish to read http://www.tek-tips.com/gviewthread.cfm/pid/183/qid/354710

Please don't hesitate to contact me if you still have any questions

Explore our products...
http://demos.instantasp.co.uk/