How to Copy SQL Database

Please follow the links:
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server[^]
SQL Server Database Copy Tool[^]
Understanding and troubleshooting the Copy Database Wizard in SQL Server 2000[^]
How to move databases between computers that are running SQL Server[^]

I've found sp_generate_inserts to be a quick and dirty way of copying data from one system to another. It's just a stored procedure that generates INSERT statements from the data in one database so you can execute those INSERTs in another database. Once you generate the structure of the database, you'd just need to use that stored procedure to copy over the data. Example usage:

EXEC sp_generate_inserts 'MyFirstTable'
EXEC sp_generate_inserts 'MySecondTable'

Where do I need to use these scripts

EXEC sp_generate_inserts 'MyFirstTable'
EXEC sp_generate_inserts 'MySecondTable'

I added this at the end of the generated sql script but its giving
Could not find stored procedure 'sp_generate_inserts' error

I created that stored procedure which is given in that link but no luck :(
still the same error