Moving stored procedures

[Timppa]

Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

colpo

[aaj]

Are you meaning copy rather than move, if so....

You can just copy the SQL text from the SP and paste it into a new SP in the
new database and then save it under the same name as the first SP

Or right click the tables in your new access front end and import
tables,views,sps etc from the original one (it generates all the scripts)

hope this helps

Andy
"Timppa" <co***@jippii.fi> wrote in message
news:37**************************@posting.google.c om...

Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

colpo

[John Winterbottom]

"Timppa" <co***@jippii.fi> wrote in message
news:37**************************@posting.google.c om...

Hi,

I have application with Access 2000 .adp and Sql Server 2000.
What is easiest way to move stored procedures from another database to
another database ?

Easiest way is probably to use DTS from Enterprise Manager (Tools --> Data
Transformation Services --> Import). A better way is to use EM to script all
the procedures into a single file then use Query Analyzer to load the file
and run the script against the target db. This way you get back information
about any errors in the script.