I have got to be overlooking something... Surely it can't be that difficult to copy stored procedures and views from one database to another on the same server. Seems strange that I can right-mouse click and select copy, but when I move down to the other database there isn't any "Paste" option.
I am working on SQL Server 2000. I don't want to move tables, just SP, Views, And Functions. What is the EASIST way to do this?