>;- ) That has occurred to me, but there are 47 stored procedures that I need to copy, plus 2 user setups, plus 4 or 5 roles, so I was looking for something easy.
>
>I am puzzled by this: When I highlight and right click on a stored procedure, one of the options on the popup is 'copy', but I have no idea how to 'paste' whatever it is I am copying!
>
>Marie

Marie,

You need to open query analyzer, connect to your server and make the database you want to copy the SP to the active db, then past the SP into query analyzer and run the query. This will put the SP into the other database.

BOb