Restore SP

How to you restore SP from one db to another? I tried a
backup restore and get the message "you can't over write
the .mdf file?What do you mean by "SP"? Stored procedure? If so, just generate scrip from
the existing database and apply that script on the destination database.
--
Tibor Karaszi
"Shelley" <anonymous@.discussions.microsoft.com> wrote in message
news:0f2101c3a3a8$bea16fb0$a101280a@.phx.gbl...
> How to you restore SP from one db to another? I tried a
> backup restore and get the message "you can't over write
> the .mdf file?