Permissions Requires ALTER permission on the database. Use SQL Server Management Studio To view or change the compatibility level of a database using SQL Server Management Studio (SSMS) Connect to the appropriate server or instance hosting your database. Select the server name in Object Explorer....
Permissions Set or change the database collation Data after changing the collation Show 2 more Applies to: SQL Server Azure SQL Managed Instance This article describes how to set or change the database collation by using SQL Server Management Studio (SSMS) or Transact-SQL. If no d...
Permissions Requires ALTER permission on the database. Using SQL Server Management Studio To change the option settings for a database In Object Explorer, connect to a Database Engine instance, expand the server, expandDatabases, right-click a database, and then clickProperties. ...
johlju changed the title xSQLServerDatabasePermissions: Localization should change to align with HQRM modules SqlDatabasePermission: Localization should change to align with HQRM modules Dec 23, 2017 johlju added in progress and removed help wanted labels Apr 26, 2019 johlju added a commit to...
Permissions Thesysadminpermissions are required to enable or disable change data capture in SQL Server and Azure SQL Managed Instance. Enable for a database Before you can create a capture instance for individual tables, you must enable change data capture for the database. ...
Permissions Enable for a database Disable for a database Enable for a table Show 2 more Applies to: SQL Server Azure SQL Managed InstanceThis article describes how to enable and disable change data capture (CDC) for a database and a table for SQL Server and Azure SQL Ma...
During installation, you have to enter credentials for the user account the service will use. This has to be a fully qualified name, e.g. if it's a local account enter.\UserName. The user has to have the necessary database permissions to carry out the replication process. ...
This cumulative update changes the permissions that are required in order to execute the sp_readerrorlog or sp_enumerrorlogs stored procedures in SQL Server 2012, 2014, or 2016. If you use either the SecurityAdmin server-level role ...
Permissions Show 2 more Applies to: Azure SQL Database Microsoft Fabric Provides the provision or deprovision status and information of theFabric Mirrored Databasefeature. This system stored procedure is used for: The Azure Synapse Link feature for SQL Server instances and Azure SQL Dat...
The login used must have SQL Server sysadmin privileges and must be a db_owner of the database. Otherwise, you’ll get the following error Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 193 The failure occurred when executing the command ‘SetCDCTracked(Value = ...