Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
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 Create a Publication.
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.
Select OK.
You can enable a database for replication with the following Transact-SQL code:
USE master
EXEC sp_replicationdboption @dbname = 'AdventureWorks2022',
@optname = 'publish',
@value = 'true'
GO
To disable publishing, set the @value = 'false'.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today