Skip to content

Commit 0bf08ad

Browse files
rothjarothja
committed
More fixes
1 parent 437bc69 commit 0bf08ad

16 files changed

Lines changed: 50 additions & 48 deletions

‎docs/integration-services/connection-manager/ado-net-connection-manager.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -104,7 +104,7 @@ To use managed identity authentication for Azure SQL Managed Instance, follow th
104104

105105
1. [Provision an Azure Active Directory administrator](/azure/sql-database/sql-database-aad-authentication-configure#provision-an-azure-active-directory-administrator-for-your-managed-instance) for your managed instance on the Azure portal, if you haven't already done so. The Azure AD administrator can be an Azure AD user or Azure AD group. If you grant the group with managed identity an admin role, skip step 2-4. The administrator will have full access to the database.
106106

107-
1. [Create logins](../../t-sql/statements/create-login-transact-sql.md?view=azuresqldb-mi-current) for the data factory managed identity. In SQL Server Management Studio (SSMS), connect to your Managed Instance using a SQL Server account that is a **sysadmin**. In **master** database, run the following T-SQL:
107+
1. [Create logins](../../t-sql/statements/create-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true) for the data factory managed identity. In SQL Server Management Studio (SSMS), connect to your Managed Instance using a SQL Server account that is a **sysadmin**. In **master** database, run the following T-SQL:
108108

109109
```sql
110110
CREATE LOGIN [your data factory name] FROM EXTERNAL PROVIDER;
@@ -116,7 +116,7 @@ To use managed identity authentication for Azure SQL Managed Instance, follow th
116116
CREATE USER [your data factory name] FROM EXTERNAL PROVIDER;
117117
```
118118

119-
1. Grant the data factory managed identity needed permissions as you normally do for SQL users and others. Run the following code. For more options, see [this document](../../t-sql/statements/alter-role-transact-sql.md?view=azuresqldb-mi-current).
119+
1. Grant the data factory managed identity needed permissions as you normally do for SQL users and others. Run the following code. For more options, see [this document](../../t-sql/statements/alter-role-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true).
120120

121121
```sql
122122
ALTER ROLE [role name e.g., db_owner] ADD MEMBER [your data factory name];

‎docs/integration-services/connection-manager/ole-db-connection-manager.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -106,7 +106,7 @@ To use managed identity authentication for Azure SQL Managed Instance, follow th
106106

107107
1. [Provision an Azure Active Directory administrator](/azure/sql-database/sql-database-aad-authentication-configure#provision-an-azure-active-directory-administrator-for-your-managed-instance) for your managed instance on the Azure portal, if you haven't already done so. The Azure AD administrator can be an Azure AD user or Azure AD group. If you grant the group with managed identity an admin role, skip step 2-4. The administrator will have full access to the database.
108108

109-
1. [Create logins](../../t-sql/statements/create-login-transact-sql.md?view=azuresqldb-mi-current) for the data factory managed identity. In SQL Server Management Studio (SSMS), connect to your Managed Instance using a SQL Server account that is a **sysadmin**. In **master** database, run the following T-SQL:
109+
1. [Create logins](../../t-sql/statements/create-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true) for the data factory managed identity. In SQL Server Management Studio (SSMS), connect to your Managed Instance using a SQL Server account that is a **sysadmin**. In **master** database, run the following T-SQL:
110110

111111
```sql
112112
CREATE LOGIN [your data factory name] FROM EXTERNAL PROVIDER;
@@ -118,7 +118,7 @@ To use managed identity authentication for Azure SQL Managed Instance, follow th
118118
CREATE USER [your data factory name] FROM EXTERNAL PROVIDER;
119119
```
120120

121-
1. Grant the data factory managed identity needed permissions as you normally do for SQL users and others. Run the following code. For more options, see [this document](../../t-sql/statements/alter-role-transact-sql.md?view=azuresqldb-mi-current).
121+
1. Grant the data factory managed identity needed permissions as you normally do for SQL users and others. Run the following code. For more options, see [this document](../../t-sql/statements/alter-role-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true).
122122

123123
```sql
124124
ALTER ROLE [role name e.g., db_owner] ADD MEMBER [your data factory name];

‎docs/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -60,7 +60,7 @@ For more information about the syntax conventions, see [Transact-SQL Syntax Conv
6060
**_\* SQL Server \*_**  
6161
:::column-end:::
6262
:::column:::
63-
[SQL Managed Instance](alter-database-transact-sql-file-and-filegroup-options.md?view=azuresqldb-mi-current)
63+
[SQL Managed Instance](alter-database-transact-sql-file-and-filegroup-options.mdview=azuresqldb-mi-current&preserve-view=true)
6464
:::column-end:::
6565
:::row-end:::
6666

@@ -1097,7 +1097,7 @@ GO
10971097

10981098
## See Also
10991099

1100-
- [CREATE DATABASE](../../t-sql/statements/create-database-transact-sql.md?view=azuresqldb-mi-current)
1100+
- [CREATE DATABASE](../../t-sql/statements/create-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
11011101
- [DATABASEPROPERTYEX](../../t-sql/functions/databasepropertyex-transact-sql.md)
11021102
- [DROP DATABASE](../../t-sql/statements/drop-database-transact-sql.md)
11031103
- [sp_spaceused](../../relational-databases/system-stored-procedures/sp-spaceused-transact-sql.md)

‎docs/t-sql/statements/alter-database-transact-sql-set-options.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -57,7 +57,7 @@ In the following row, select whichever product name you're interested in. Doing
5757
[SQL Database](alter-database-transact-sql-set-options.md?view=azuresqldb-current&preserve-view=true)
5858
:::column-end:::
5959
:::column:::
60-
[SQL Managed Instance](alter-database-transact-sql-set-options.md?view=azuresqldb-mi-current)
60+
[SQL Managed Instance](alter-database-transact-sql-set-options.mdview=azuresqldb-mi-current&preserve-view=true)
6161
:::column-end:::
6262
:::column:::
6363
[Azure Synapse<br />Analytics](alter-database-transact-sql-set-options.md?view=azure-sqldw-latest&preserve-view=true)
@@ -1488,7 +1488,7 @@ SET QUERY_STORE = ON
14881488
**_\* SQL Database \*_** &nbsp;
14891489
:::column-end:::
14901490
:::column:::
1491-
[SQL Managed Instance](alter-database-transact-sql-set-options.md?view=azuresqldb-mi-current)
1491+
[SQL Managed Instance](alter-database-transact-sql-set-options.mdview=azuresqldb-mi-current&preserve-view=true)
14921492
:::column-end:::
14931493
:::column:::
14941494
[Azure Synapse<br />Analytics](alter-database-transact-sql-set-options.md?view=azure-sqldw-latest&preserve-view=true)
@@ -3157,7 +3157,7 @@ SET QUERY_STORE = ON
31573157
- [ALTER DATABASE Compatibility Level](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md)
31583158
- [ALTER DATABASE Database Mirroring](../../t-sql/statements/alter-database-transact-sql-database-mirroring.md)
31593159
- [Statistics](../../relational-databases/statistics/statistics.md)
3160-
- [CREATE DATABASE](../../t-sql/statements/create-database-transact-sql.md?view=azuresqldb-mi-current)
3160+
- [CREATE DATABASE](../../t-sql/statements/create-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
31613161
- [Enable and Disable Change Tracking](../../relational-databases/track-changes/enable-and-disable-change-tracking-sql-server.md)
31623162
- [DATABASEPROPERTYEX](../../t-sql/functions/databasepropertyex-transact-sql.md)
31633163
- [DROP DATABASE](../../t-sql/statements/drop-database-transact-sql.md)
@@ -3178,7 +3178,7 @@ SET QUERY_STORE = ON
31783178
[SQL Database](alter-database-transact-sql-set-options.md?view=azuresqldb-current&preserve-view=true)
31793179
:::column-end:::
31803180
:::column:::
3181-
[SQL Managed Instance](alter-database-transact-sql-set-options.md?view=azuresqldb-mi-current)
3181+
[SQL Managed Instance](alter-database-transact-sql-set-options.mdview=azuresqldb-mi-current&preserve-view=true)
31823182
:::column-end:::
31833183
:::column:::
31843184
**_\* Azure Synapse<br />Analytics \*_** &nbsp;

‎docs/t-sql/statements/alter-database-transact-sql.md‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -48,7 +48,7 @@ For more information about the syntax conventions, see [Transact-SQL Syntax Conv
4848
[SQL Database](alter-database-transact-sql.md?view=azuresqldb-current&preserve-view=true)
4949
:::column-end:::
5050
:::column:::
51-
[SQL Managed Instance](alter-database-transact-sql.md?view=azuresqldb-mi-current)
51+
[SQL Managed Instance](alter-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
5252
:::column-end:::
5353
:::column:::
5454
[Azure Synapse<br />Analytics](alter-database-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -301,7 +301,7 @@ GO
301301
**_\* SQL Database \*_** &nbsp;
302302
:::column-end:::
303303
:::column:::
304-
[SQL Managed Instance](alter-database-transact-sql.md?view=azuresqldb-mi-current)
304+
[SQL Managed Instance](alter-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
305305
:::column-end:::
306306
:::column:::
307307
[Azure Synapse<br />Analytics](alter-database-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -901,7 +901,7 @@ ALTER DATABASE WideWorldImporters
901901

902902
## See also
903903

904-
- [CREATE DATABASE - Azure SQL Database](../../t-sql/statements/create-database-transact-sql.md?view=azuresqldb-mi-current)
904+
- [CREATE DATABASE - Azure SQL Database](../../t-sql/statements/create-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
905905
- [DATABASEPROPERTYEX](../../t-sql/functions/databasepropertyex-transact-sql.md)
906906
- [DROP DATABASE](../../t-sql/statements/drop-database-transact-sql.md)
907907
- [SET TRANSACTION ISOLATION LEVEL](../../t-sql/statements/set-transaction-isolation-level-transact-sql.md)
@@ -926,7 +926,7 @@ ALTER DATABASE WideWorldImporters
926926
[SQL Database](alter-database-transact-sql.md?view=azuresqldb-current&preserve-view=true)
927927
:::column-end:::
928928
:::column:::
929-
[SQL Managed Instance](alter-database-transact-sql.md?view=azuresqldb-mi-current)
929+
[SQL Managed Instance](alter-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
930930
:::column-end:::
931931
:::column:::
932932
**_\* Azure Synapse<br />Analytics \*_** &nbsp;
@@ -1105,7 +1105,7 @@ ALTER DATABASE dw1 MODIFY ( MAXSIZE=10240 GB, SERVICE_OBJECTIVE= 'DW1200' );
11051105
[SQL Database](alter-database-transact-sql.md?view=azuresqldb-current&preserve-view=true)
11061106
:::column-end:::
11071107
:::column:::
1108-
[SQL Managed Instance](alter-database-transact-sql.md?view=azuresqldb-mi-current)
1108+
[SQL Managed Instance](alter-database-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
11091109
:::column-end:::
11101110
:::column:::
11111111
[Azure Synapse<br />Analytics](alter-database-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)

‎docs/t-sql/statements/alter-login-transact-sql.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -44,7 +44,7 @@ Changes the properties of a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md
4444
[SQL Database](alter-login-transact-sql.md?view=azuresqldb-current&preserve-view=true)
4545
:::column-end:::
4646
:::column:::
47-
[SQL Managed Instance](alter-login-transact-sql.md?view=azuresqldb-mi-current)
47+
[SQL Managed Instance](alter-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
4848
:::column-end:::
4949
:::column:::
5050
[Azure Synapse<br />Analytics](alter-login-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -295,7 +295,7 @@ GO
295295
**_\* SQL Database \*_**
296296
:::column-end:::
297297
:::column:::
298-
[SQL Managed Instance](alter-login-transact-sql.md?view=azuresqldb-mi-current)
298+
[SQL Managed Instance](alter-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
299299
:::column-end:::
300300
:::column:::
301301
[Azure Synapse<br />Analytics](alter-login-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -753,7 +753,7 @@ ALTER LOGIN [joe@contoso.com] DISABLE
753753
[SQL Database](alter-login-transact-sql.md?view=azuresqldb-current&preserve-view=true)
754754
:::column-end:::
755755
:::column:::
756-
[SQL Managed Instance](alter-login-transact-sql.md?view=azuresqldb-mi-current)
756+
[SQL Managed Instance](alter-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
757757
:::column-end:::
758758
:::column:::
759759
**_\* Azure Synapse<br />Analytics \*_**
@@ -927,7 +927,7 @@ GO
927927
[SQL Database](alter-login-transact-sql.md?view=azuresqldb-current&preserve-view=true)
928928
:::column-end:::
929929
:::column:::
930-
[SQL Managed Instance](alter-login-transact-sql.md?view=azuresqldb-mi-current)
930+
[SQL Managed Instance](alter-login-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
931931
:::column-end:::
932932
:::column:::
933933
[Azure Synapse<br />Analytics](alter-login-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)

‎docs/t-sql/statements/alter-user-transact-sql.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -45,7 +45,7 @@ Renames a database user or changes its default schema.
4545
[SQL Database](alter-user-transact-sql.md?view=azuresqldb-current&preserve-view=true)
4646
:::column-end:::
4747
:::column:::
48-
[SQL Managed Instance](alter-user-transact-sql.md?view=azuresqldb-mi-current)
48+
[SQL Managed Instance](alter-user-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
4949
:::column-end:::
5050
:::column:::
5151
[Azure Synapse<br />Analytics](alter-user-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -228,7 +228,7 @@ GO
228228
**_\* SQL Database \*_**
229229
:::column-end:::
230230
:::column:::
231-
[SQL Managed Instance](alter-user-transact-sql.md?view=azuresqldb-mi-current)
231+
[SQL Managed Instance](alter-user-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
232232
:::column-end:::
233233
:::column:::
234234
[Azure Synapse<br />Analytics](alter-user-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -696,7 +696,7 @@ ALTER USER [westus\mygroup] WITH LOGIN = mygroup
696696
[SQL Database](alter-user-transact-sql.md?view=azuresqldb-current&preserve-view=true)
697697
:::column-end:::
698698
:::column:::
699-
[SQL Managed Instance](alter-user-transact-sql.md?view=azuresqldb-mi-current)
699+
[SQL Managed Instance](alter-user-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
700700
:::column-end:::
701701
:::column:::
702702
**_\* Azure Synapse<br />Analytics \*_**
@@ -825,7 +825,7 @@ GO
825825
[SQL Database](alter-user-transact-sql.md?view=azuresqldb-current&preserve-view=true)
826826
:::column-end:::
827827
:::column:::
828-
[SQL Managed Instance](alter-user-transact-sql.md?view=azuresqldb-mi-current)
828+
[SQL Managed Instance](alter-user-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
829829
:::column-end:::
830830
:::column:::
831831
[Azure Synapse<br />Analytics](alter-user-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)

‎docs/t-sql/statements/alter-workload-group-transact-sql.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ monikerRange: ">=sql-server-2016||>=sql-server-linux-2017||=azure-sqldw-latest||
3131
**_\* SQL Server \*_** &nbsp;
3232
:::column-end:::
3333
:::column:::
34-
[SQL Managed Instance](alter-workload-group-transact-sql.md?view=azuresqldb-mi-current)
34+
[SQL Managed Instance](alter-workload-group-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
3535
:::column-end:::
3636
:::column:::
3737
[Azure Synapse<br />Analytics](alter-workload-group-transact-sql.md?view=azure-sqldw-latest&preserve-view=true)
@@ -73,7 +73,7 @@ monikerRange: ">=sql-server-2016||>=sql-server-linux-2017||=azure-sqldw-latest||
7373
[SQL Server](alter-workload-group-transact-sql.md?view=sql-server-ver15&preserve-view=true)
7474
:::column-end:::
7575
:::column:::
76-
[SQL Managed Instance](alter-workload-group-transact-sql.md?view=azuresqldb-mi-current)
76+
[SQL Managed Instance](alter-workload-group-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
7777
:::column-end:::
7878
:::column:::
7979
**_\* Azure Synapse<br />Analytics \*_** &nbsp;

‎docs/t-sql/statements/backup-transact-sql.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -65,7 +65,7 @@ For more information about the syntax conventions, see [Transact-SQL Syntax Conv
6565
**_\* SQL Server \*_** &nbsp;
6666
:::column-end:::
6767
:::column:::
68-
[SQL Managed Instance](backup-transact-sql.md?view=azuresqldb-mi-current)
68+
[SQL Managed Instance](backup-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
6969
:::column-end:::
7070
:::column:::
7171
[Analytics Platform<br />System (PDW)](backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
@@ -1204,7 +1204,7 @@ WITH STATS = 5, COPY_ONLY;
12041204
[SQL Server](backup-transact-sql.md?view=sql-server-ver15&preserve-view=true)
12051205
:::column-end:::
12061206
:::column:::
1207-
[SQL Managed Instance](backup-transact-sql.md?view=azuresqldb-mi-current)
1207+
[SQL Managed Instance](backup-transact-sql.mdview=azuresqldb-mi-current&preserve-view=true)
12081208
:::column-end:::
12091209
:::column:::
12101210
**_\* Analytics<br />Platform System (PDW) \*_** &nbsp;

‎docs/t-sql/statements/copy-into-transact-sql.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -269,8 +269,8 @@ IDENTITY_INSERT specifies whether the identity value or values in the imported d
269269

270270
The user executing the Copy Command must have the following permissions:
271271

272-
- [ADMINISTER DATABASE BULK OPERATIONS](grant-database-permissions-transact-sql.md?view=azure-sqldw-latest#remarks)
273-
- [INSERT ](grant-database-permissions-transact-sql.md?view=azure-sqldw-latest#remarks)
272+
- [ADMINISTER DATABASE BULK OPERATIONS](grant-database-permissions-transact-sql.md#remarks)
273+
- [INSERT ](grant-database-permissions-transact-sql.md#remarks)
274274

275275
Requires INSERT and ADMINISTER BULK OPERATIONS permissions. In [!INCLUDE[ssSDW](../../includes/sssdwfull-md.md)], INSERT, and ADMINISTER DATABASE BULK OPERATIONS permissions are required.
276276

0 commit comments

Comments
 (0)