Skip to content

Commit cca3630

Browse files
SaisangSaisang
committed
manual fix multiple asterisks
1 parent b44092e commit cca3630

16 files changed

Lines changed: 69 additions & 69 deletions

‎docs/2014/database-engine/configure-windows/diagnostic-connection-for-database-administrators.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@ manager: craigg
3737

3838
Only members of the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] sysadmin role can connect using the DAC.
3939

40-
The DAC is available and supported through the **sqlcmd** command-prompt utility using a special administrator switch (**-A**). For more information about using **sqlcmd**, see [Use sqlcmd with Scripting Variables](../../relational-databases/scripting/sqlcmd-use-with-scripting-variables.md). You can also connect prefixing `admin:`to the instance name in the format **sqlcmd -Sadmin:***<instance_name>.* You can also initiate a DAC from a [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] Query Editor by connecting to `admin:`\<*instance_name*>.
40+
The DAC is available and supported through the **sqlcmd** command-prompt utility using a special administrator switch (**-A**). For more information about using **sqlcmd**, see [Use sqlcmd with Scripting Variables](../../relational-databases/scripting/sqlcmd-use-with-scripting-variables.md). You can also connect prefixing `admin:`to the instance name in the format **sqlcmd -Sadmin:**_<instance_name>._ You can also initiate a DAC from a [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] Query Editor by connecting to `admin:`\<*instance_name*>.
4141

4242
## Restrictions
4343
Because the DAC exists solely for diagnosing server problems in rare circumstances, there are some restrictions on the connection:
@@ -87,7 +87,7 @@ manager: craigg
8787

8888
The DAC port is assigned dynamically by [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] during startup. When connecting to the default instance, the DAC avoids using a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Resolution Protocol (SSRP) request to the SQL Server Browser Service when connecting. It first connects over TCP port 1434. If that fails, it makes an SSRP call to get the port. If [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Browser is not listening for SSRP requests, the connection request returns an error. Refer to the error log to find the port number DAC is listening on. If [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] is configured to accept remote administration connections, the DAC must be initiated with an explicit port number:
8989

90-
**sqlcmd-Stcp:** *\<server>,\<port>*
90+
**sqlcmd-Stcp:** _\<server>,\<port>_
9191

9292
The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] error log lists the port number for the DAC, which is 1434 by default. If [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] is configured to accept local DAC connections only, connect using the loopback adapter using the following command:
9393

‎docs/2014/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -77,7 +77,7 @@ manager: craigg
7777

7878
### <a name="ConfigureServerConnections"></a> To configure the server to accept encrypted connections
7979

80-
1. In **SQL Server Configuration Manager**, expand **SQL Server Network Configuration**, right-click **Protocols for** *\<server instance>*, and then select**Properties**.
80+
1. In **SQL Server Configuration Manager**, expand **SQL Server Network Configuration**, right-click **Protocols for** _\<server instance>_, and then select**Properties**.
8181

8282
2. In the **Protocols for**_\<instance name>_ **Properties** dialog box, on the **Certificate** tab, select the desired certificate from the drop down for the **Certificate** box, and then click **OK**.
8383

‎docs/2014/database-engine/database-mirroring/database-mirroring-establish-session-windows-authentication.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -63,7 +63,7 @@ manager: craigg
6363
6464
The syntax for a server network address is as follows:
6565
66-
TCP**://**\<*system-address>***:**\<*port>*
66+
TCP<strong>://</strong>\<*system-address>*<strong>:</strong>\<*port>*
6767
6868
where \<*system-address>* is a string that unambiguously identifies the destination computer system, and \<*port>* is the port number used by the mirroring endpoint of the partner server instance. For more information, see [Specify a Server Network Address &#40;Database Mirroring&#41;](specify-a-server-network-address-database-mirroring.md).
6969

‎docs/2014/database-engine/discontinued-database-engine-functionality-in-sql-server-2016.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -69,7 +69,7 @@ manager: craigg
6969
|System tables|sys.database_principal_aliases|Use roles instead of aliases.|
7070
|Transact-SQL|`RAISERROR` in the format `RAISERROR integer 'string'` is discontinued.|Rewrite the statement using the current **RAISERROR(...)** syntax.|
7171
|Transact-SQL syntax|`COMPUTE / COMPUTE BY`|Use `ROLLUP`|
72-
|Transact-SQL syntax|Use of **\*=** and **=\***|Use ANSI join syntax. For more information, see [FROM (Transact-SQL).](https://msdn.microsoft.com/library/ms177634\(SQL.105\).aspx)|
72+
|Transact-SQL syntax|Use of **\*=** and **=&#42;**|Use ANSI join syntax. For more information, see [FROM (Transact-SQL).](https://msdn.microsoft.com/library/ms177634\(SQL.105\).aspx)|
7373
|XEvents|databases_data_file_size_changed, databases_log_file_size_changed<br /><br /> eventdatabases_log_file_used_size_changed<br /><br /> locks_lock_timeouts_greater_than_0<br /><br /> locks_lock_timeouts|Replaced by database_file_size_change event, database_file_size_change<br /><br /> database_file_size_change event<br /><br /> lock_timeout_greater_than_0<br /><br /> lock_timeout|
7474

7575
**Additional XEvent changes**

0 commit comments

Comments
 (0)