Skip to content

Commit d68793d

Browse files
20211022 1435
1 parent d028d19 commit d68793d

20 files changed

Lines changed: 50 additions & 42 deletions

docs/relational-databases/collations/set-or-change-the-server-collation.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -68,7 +68,7 @@ Server-level collation in Azure SQL Managed Instance can be specified when the i
6868

6969
If you are migrating databases from SQL Server to Managed Instance, check the server collation in the source SQL Server using `SERVERPROPERTY(N'Collation')` function and create a Managed Instance that matches the collation of your SQL Server. Migrating a database from SQL Server to Managed Instance with the server-level collations that are not matched might cause several unexpected errors in the queries. You cannot change the server-level collation on the existing Managed Instance.
7070

71-
## See Also
71+
## Next Steps
7272

7373
- [Collation and Unicode Support](../../relational-databases/collations/collation-and-unicode-support.md)
7474
- [Set or Change the Database Collation](../../relational-databases/collations/set-or-change-the-database-collation.md)

docs/relational-databases/databases/create-a-database.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -109,7 +109,8 @@ GO
109109

110110
For more examples, see [CREATE DATABASE (SQL Server Transact-SQL)](../../t-sql/statements/create-database-transact-sql.md).
111111

112-
## See Also
112+
## Next Steps
113+
113114
- [Database Files and Filegroups](../../relational-databases/databases/database-files-and-filegroups.md)
114115
- [Database Detach and Attach (SQL Server)](../../relational-databases/databases/database-detach-and-attach-sql-server.md)
115116
- [ALTER DATABASE (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql.md)

docs/relational-databases/databases/rename-a-database.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -108,7 +108,7 @@ ALTER LOGIN [login] WITH DEFAULT_DATABASE=[new-database-name];
108108
GO
109109
```
110110

111-
## See Also
111+
## Next Steps
112112

113113
- [ALTER DATABASE (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql.md)
114114
- [Database Identifiers](../../relational-databases/databases/database-identifiers.md)

docs/relational-databases/databases/set-a-database-to-single-user-mode.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -61,7 +61,7 @@ ms.author: wiassaf
6161
6262
[!code-sql[DatabaseDDL#AlterDatabase8](../../relational-databases/databases/codesnippet/tsql/set-a-database-to-single_1.sql)]
6363

64-
## See Also
64+
## Next Steps
6565
- [ALTER DATABASE (Transact-SQL)](../../t-sql/statements/alter-database-transact-sql.md)
6666

6767

docs/relational-databases/databases/shrink-a-database.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -92,7 +92,7 @@ monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||
9292

9393
Data that is moved to shrink a file can be scattered to any available location in the file. This causes index fragmentation and can slow the performance of queries that search a range of the index. To eliminate the fragmentation, consider rebuilding the indexes on the file after shrinking.
9494

95-
## See Also
95+
## Next Steps
9696
- [Shrink a File](../../relational-databases/databases/shrink-a-file.md)
9797
- [sys.databases (Transact-SQL)](../../relational-databases/system-catalog-views/sys-databases-transact-sql.md)
9898
- [sys.database_files (Transact-SQL)](../../relational-databases/system-catalog-views/sys-database-files-transact-sql.md)

docs/relational-databases/databases/use-the-copy-database-wizard.md

Lines changed: 17 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -284,7 +284,8 @@ Opens the **New Job Schedule** dialog box. Configure as desired. Select **OK**
284284
- **Integration Services Proxy account**
285285
Select an available proxy account from the drop-down list. To schedule the transfer, there must be at least one proxy account available to the user, configured with permission to the **SSIS package execution subsystem**.
286286

287-
To create a proxy account for SSIS package execution, in **Object Explorer**, expand **SQL Server Agent**, expand **Proxies**, right-click **SSIS Package Execution**, and then select **New Proxy**.
287+
> [!NOTE]
288+
> To create a proxy account for SSIS package execution, in **Object Explorer**, expand **SQL Server Agent**, expand **Proxies**, right-click **SSIS Package Execution**, and then select **New Proxy**.
288289

289290
### Complete the wizard
290291
Displays summary of the selected options. Select **Back** to change an option. Select **Finish** to create the SSIS package. The **Performing operation** page monitors status information about the execution of the **Copy Database Wizard**.
@@ -345,18 +346,18 @@ The following example will move the `Sales` database, a Windows login named `con
345346
16. **Post Move Steps**
346347
Consider executing the following T-SQL statements on the new host, `Server2`:
347348

348-
```tsql
349-
ALTER AUTHORIZATION ON DATABASE::Sales TO sa;
350-
GO
351-
ALTER DATABASE Sales
352-
SET COMPATIBILITY_LEVEL = 130;
353-
GO
354-
355-
USE [Sales]
356-
GO
357-
EXEC sp_updatestats;
358-
GO
359-
```
349+
```tsql
350+
ALTER AUTHORIZATION ON DATABASE::Sales TO sa;
351+
GO
352+
ALTER DATABASE Sales
353+
SET COMPATIBILITY_LEVEL = 130;
354+
GO
355+
356+
USE [Sales]
357+
GO
358+
EXEC sp_updatestats;
359+
GO
360+
```
360361

361362
17. **Post Move Steps Cleanup**
362363
Since `Server1` will be moved to a different team and the **Move** operation will not be repeated, consider executing the following steps:
@@ -379,9 +380,9 @@ In this example, the `Sales` database will be copied and created as `SalesCopy`
379380

380381
10. **Schedule the Package** page: Select the **Schedule:** radio button and then select the **Change Schedule** button.
381382

382-
1. **New Job Schedule** page: In the **Name** text box enter `Weekly on Sunday`.
383-
384-
2. Select **OK**.
383+
1. **New Job Schedule** page: In the **Name** text box enter "Weekly on Sunday".
384+
385+
2. Select **OK**.
385386

386387
11. Select the relevant proxy from the **Integration Services Proxy account** drop-down list. Select **Next**.
387388

docs/relational-databases/databases/view-a-list-of-databases-on-an-instance-of-sql-server.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -55,7 +55,8 @@ GO
5555

5656
```
5757

58-
## See Also
58+
## Next Steps
59+
5960
- [Databases and Files Catalog Views (Transact-SQL)](../../relational-databases/system-catalog-views/databases-and-files-catalog-views-transact-sql.md)
6061
- [sys.databases (Transact-SQL)](../../relational-databases/system-catalog-views/sys-databases-transact-sql.md)
6162

docs/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -76,5 +76,5 @@ SET COMPATIBILITY_LEVEL = 120;
7676
GO
7777
```
7878

79-
## See Also
79+
## Next Steps
8080
- [ALTER DATABASE (Transact-SQL) Compatibility Level](../../t-sql/statements/alter-database-transact-sql-compatibility-level.md)

docs/relational-databases/json/format-query-results-as-json-with-for-json-sql-server.md

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -242,7 +242,8 @@ For a visual introduction to the built-in JSON support in SQL Server and Azure S
242242

243243
- [JSON as a bridge between NoSQL and relational worlds](https://channel9.msdn.com/events/DataDriven/SQLServer2016/JSON-as-a-bridge-betwen-NoSQL-and-relational-worlds)
244244

245-
## See Also
245+
## Next Steps
246+
246247
- [FOR Clause (Transact-SQL)](../../t-sql/queries/select-for-clause-transact-sql.md)
247248
- [Use FOR JSON output in SQL Server and in client apps (SQL Server)](../../relational-databases/json/use-for-json-output-in-sql-server-and-in-client-apps-sql-server.md)
248249

docs/relational-databases/json/json-data-sql-server.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -406,7 +406,7 @@ For a visual introduction to the built-in JSON support in SQL Server and Azure S
406406
*Building REST API with SQL Server using JSON functions*
407407
> [!VIDEO https://www.youtube.com/embed/0m6GXF3-5WI]
408408
409-
### Next
409+
## Next Steps
410410

411411
- [FOR Clause (Transact-SQL)](../../t-sql/queries/select-for-clause-transact-sql.md) (FOR JSON)
412412
- [OPENJSON (Transact-SQL)](../../t-sql/functions/openjson-transact-sql.md)

0 commit comments

Comments
 (0)