How to: Enable a Database for Replication (SQL Server Management Studio)
A database is implicitly enabled for replication when a member of the sysadmin fixed server role creates a publication with the New Publication Wizard. A member of the sysadmin fixed server role can also enable a database for replication explicitly, so that a member of the db_owner fixed database role can create one or more publications in that database. To enable a database explicitly, use the Publication Databases page of the Publisher Properties - <Publisher> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publisher Properties (SQL Server Management Studio).
To enable a database for replication
On the Publication Databases page of the Publisher Properties - <Publisher> dialog box, select the Transactional and/or Merge check box for each database you want to replicate. Select Transactional to enable the database for snapshot replication.
Click OK.
See Also
Other Resources
How to: Create a Publication (Replication Transact-SQL Programming)