Create
the Database and Table in Enterprise Manager
Let's go to MSSQL
Server 2000 Enterprise Manager ("Enterprise Manager") to
create our new source.
1.
Click Start.
2.
Navigate to
the Microsoft SQL Server program group that installs within a
typical setup. The equivalent on my PC appears as shown in Illustration 3.
3.
Click Enterprise
Manager (shown circled above) to initialize the application.
We
arrive within the Enterprise Manager Management Console, as shown in Illustration
4.
Illustration 4: In the Enterprise
Manager Management Console (Compressed View)
4.
Expand the MSSQL
Servers group object by clicking the "+" sign to its immediate
left.
5.
Expand the SQL
Server Group object that next appears.
6.
Expand the
server to which you intend to connect next (mine appears as LOCAL), as
depicted in Illustration 5).
Illustration 5: Expand
the Selected Server (Compressed View)
NOTE: The registered servers and other
objects will appear different in this view on your own PC, and will depend upon
your environment.
7.
Right-click
the Databases folder under the selected server.
8.
Select New
Database on the context menu that appears, as shown in Illustration 6.
Illustration 6: Select
New Database ...
The Database
Properties dialog appears, defaulted to the General tab.
9.
Type the
following into the Name box on the General tab:
RS_Subscription
The Database
Properties dialog - General tab appears as shown in Illustration 7.
Illustration 7: Database
Properties Dialog - General Tab
10.
Click the Data
Files tab.
11.
Ascertain that
the default location is satisfactory for the placement of the new database. If
not, make appropriate changes.
The Database
Properties dialog - Data Files tab for my server (I left all at default)
appears as shown in Illustration 8.
Illustration 8: Database
Properties Dialog - Data Files Tab
12.
Click the Transaction
Log tab.
I again
left my settings at default; the Database Properties dialog - Transaction
Log tab for my server appears as shown in Illustration 9.
Illustration 9: Database
Properties Dialog - Transaction Log Tab
13.
After making
any necessary adjustments specific to your environment, click OK to
create the new RS_Subscription database.