I have ms SQL 2000 and enterprise manager
I have created my database on my loclahost, with all stored preocedures and views, and all the datas in it

how can I put it on on remote host ??

where can I find all the information step to step

I had this answer without no more information : (3 ways)

1)Using Enterprise Manager, connect to the remote SQL Server instance and allow yourself to work with the remote instance directly.

2)Use the Generate script capability of Enterprise Manager (or manually run the system stored procedure for this yourself). Then just run the script against your remote database.

3)Detach the database and upload it to the remote server. Then, log on to the remote and reattach them. Of course, an empty database on the remote server would need to have existed and had been detached


what is the best one ?
and how to process ?
is there somewhere a step ns step tutorial online ?