I have DB1 and DB2. For some reasons, i decided to have backup of DB1.
I dont want to restore the DB1 Backup to DB2 .. due to .mdf and .ldf issues ..!
How to copy StoredProcedures, Triggers,Userdefined functions from one SQL Database to another ??? Instead of generating sql script for one by one ...