General information
Forum:
Microsoft SQL Server
Category:
Database management
>;- ) 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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only