How do I copy database from test server to live server

[mit99mh]

I'm pretty new to SQL Server 2000 and I need to copy a database from a test server to a live one including views, stored procedures etc. The tables and data from the test server will then be redundant so I've no synchronisation / publisher / subscriber issues. I was wondering what is the best way to do something like this.

Any help much appreciated.

 

[MaffewW]

Hi, I've just posted a response to this in the programming forum (didnt see this one though this was really the right place for the question). For future reference pls post in just one forum, it keeps all the responses together, amongst other reasons it keeps all the responses together.

Good luck