Notice this article is for SQL2000 and Enterprise manager only.
Use Import Export Tool (DTS) - select "Copy objects and data between SQL server".
On
the next screen, check only: one in the "Create Destination Objects..."
- one in the "Copy Data -Replace all Data..." - and one in "Copy all
objects...".
In
the box "Use Default Options", uncheck it and click the "Options"
button. In the following window, clear all of the Security check boxes.
Click OK, Next, Next and Finish.
This way all tables, views and stored procedures are transferred into the SQL Server Database.