Skip to content

Commit 6d933e2

Browse files
v-thepetv-thepet
committed
more fixes
1 parent 2874718 commit 6d933e2

57 files changed

Lines changed: 78 additions & 78 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/2014/database-engine/TOC.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -553,7 +553,7 @@
553553
###### [Revert a Database to a Database Snapshot](../relational-databases/databases/revert-a-database-to-a-database-snapshot.md)
554554
###### [Drop a Database Snapshot (Transact-SQL)](../relational-databases/databases/drop-a-database-snapshot-transact-sql.md)
555555
##### [Database Instant File Initialization](../relational-databases/databases/database-instant-file-initialization.md)
556-
#### [Tables](tables.md)
556+
#### [Tables](../relational-databases/tables.md)
557557
##### [Create Tables (Database Engine)](../relational-databases/tables/create-tables-database-engine.md)
558558
##### [Delete Tables (Database Engine)](../relational-databases/tables/delete-tables-database-engine.md)
559559
##### [Duplicate Tables](../relational-databases/tables/duplicate-tables.md)
@@ -794,7 +794,7 @@
794794
##### [Delete User-defined Functions](../relational-databases/user-defined-functions/delete-user-defined-functions.md)
795795
##### [Execute User-defined Functions](../relational-databases/user-defined-functions/execute-user-defined-functions.md)
796796
##### [Rename User-defined Functions](../relational-databases/user-defined-functions/rename-user-defined-functions.md)
797-
##### [View User-defined Functions](view-../relational-databases/user-defined-functions/user-defined-functions.md)
797+
##### [View User-defined Functions](../relational-databases/user-defined-functions/view-user-defined-functions.md)
798798
#### [Statistics](../relational-databases/statistics/statistics.md)
799799
##### [Create Statistics](../relational-databases/statistics/create-statistics.md)
800800
##### [Modify Statistics](../relational-databases/statistics/modify-statistics.md)
@@ -942,7 +942,7 @@
942942
##### [Polygon](../relational-databases/spatial/polygon.md)
943943
##### [CurvePolygon](../relational-databases/spatial/curvepolygon.md)
944944
##### [MultiPoint](../relational-databases/spatial/multipoint.md)
945-
##### [MultiLineString](multi../relational-databases/spatial/linestring.md)
945+
##### [MultiLineString](../relational-databases/spatial/multilinestring.md)
946946
##### [MultiPolygon](../relational-databases/spatial/multipolygon.md)
947947
##### [GeometryCollection](../relational-databases/spatial/geometrycollection.md)
948948
##### [Spatial Reference Identifiers (SRIDs)](../relational-databases/spatial/spatial-reference-identifiers-srids.md)
@@ -1148,9 +1148,9 @@
11481148
##### [OLE Automation Result Sets](../relational-databases/stored-procedures/ole-automation-result-sets.md)
11491149
##### [OLE Automation Sample Script](../relational-databases/stored-procedures/ole-automation-sample-script.md)
11501150
#### [Event Notifications](../relational-databases/service-broker/event-notifications.md)
1151-
##### [Implement Event Notifications](implement-event-notifications.md)
1151+
##### [Implement Event Notifications](../relational-databases/service-broker/implement-event-notifications.md)
11521152
##### [Configure Dialog Security for Event Notifications](../relational-databases/service-broker/configure-dialog-security-for-event-notifications.md)
1153-
##### [Get Information About Event Notifications](get-information-about-event-notifications.md)
1153+
##### [Get Information About Event Notifications](../relational-databases/service-broker/get-information-about-event-notifications.md)
11541154
#### [Monitor and Tune for Performance](../relational-databases/performance/monitor-and-tune-for-performance.md)
11551155
##### [Monitor SQL Server Components](../relational-databases/performance/monitor-sql-server-components.md)
11561156
##### [Performance Monitoring and Tuning Tools](../relational-databases/performance/performance-monitoring-and-tuning-tools.md)
@@ -1850,7 +1850,7 @@
18501850
###### [XTP Transaction Log](../relational-databases/performance-monitor/sql-server-xtp-transaction-log.md)
18511851
###### [XTP Transactions](../relational-databases/performance-monitor/sql-server-xtp-transactions.md)
18521852
#### [Administer Multiple Servers Using Central Management Servers](../relational-databases/administer-multiple-servers-using-central-management-servers.md)
1853-
#### [SQL Server Configuration Manager](sql-server-configuration-manager.md)
1853+
#### [SQL Server Configuration Manager](../relational-databases/sql-server-configuration-manager.md)
18541854
#### [Activity Monitor](../relational-databases/performance-monitor/activity-monitor.md)
18551855
##### [Open Activity Monitor (SQL Server Management Studio)](../relational-databases/performance-monitor/open-activity-monitor-sql-server-management-studio.md)
18561856
### [High Availability Solutions](high-availability-solutions-sql-server.md)

‎docs/2014/relational-databases/sequence-numbers/sequence-properties-general-page.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ manager: "jhubbard"
2222

2323
Unlike identity columns values which are generated at the time of insert, an application can obtain the next sequence number without inserting the row by calling the [NEXT VALUE FOR function](~/t-sql/functions/next-value-for-transact-sql.md). Use [sp_sequence_get_range](~/relational-databases/system-stored-procedures/sp-sequence-get-range-transact-sql.md) to get multiple sequence numbers at once.
2424

25-
For information and scenarios that use both **CREATE SEQUENCE** and the **NEXT VALUE FOR** function, see [Sequence Numbers](../relational-databases/sequence-numbers/sequence-numbers.md).
25+
For information and scenarios that use both **CREATE SEQUENCE** and the **NEXT VALUE FOR** function, see [Sequence Numbers](sequence-numbers.md).
2626

2727
This page is accessed in two ways: either by right-clicking **Sequences** in Object Explorer and clicking **New Sequence**, or by right-clicking an existing sequence and clicking **Properties**. When you right-click an existing sequence and click **Properties**, the options are not editable. To change the sequence options use the [ALTER SEQUENCE (Transact-SQL)](~/t-sql/statements/alter-sequence-transact-sql.md) statement or drop and recreate the sequence object.
2828

‎docs/2014/relational-databases/server-management-objects-smo/create-program/creating-smo-programs.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -35,7 +35,7 @@ manager: "jhubbard"
3535
|[Handling SMO Events](handling-smo-events.md)|This section describes how to set up and handle events in SMO. Includes an example of how to set up an event handler and how to set up event subscription.|
3636
|[Handling SMO Exceptions](handling-smo-exceptions.md)|This section describes how to trap exceptions in SMO. Includes examples of how to catch an exception and how to display an inner exception.|
3737
|[Working with Data Types](working-with-data-types.md)|This section describes how to work with the different [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] data types. Describes how to construct a datatype with the specification in the object constructor. Also includes example of how to create a datatype by using the default constructor.|
38-
|[Using Transactions](../../../analysis-services/multidimensional-models-adomd-net-client/transactions.md)|This section describes how to implement transaction processing in an SMO program. Includes example of how to use transactions in an SMO program.|
38+
|[Using Transactions](using-transactions.md)|This section describes how to implement transaction processing in an SMO program. Includes example of how to use transactions in an SMO program.|
3939
|[Using Capture Mode](using-capture-mode.md)|This section describes how to record the output of the SMO program. The example records the SMO program as [!INCLUDE[tsql](../../../includes/tsql-md.md)] statements sent to the instance of [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] for later execution.|
4040

4141

‎docs/2014/relational-databases/server-management-objects-smo/create-program/handling-smo-exceptions.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -34,12 +34,12 @@ manager: "jhubbard"
3434
> [!NOTE]
3535
> The `SQLException` exception is declared in the **System.Data.SqlClient** namespace.
3636
37-
![A diagram that shows the levels from which an excp](../../../2014/database-engine/dev-guide/media/exception-flow.gif "A diagram that shows the levels from which an excp")
37+
![A diagram that shows the levels from which an excp](../../../database-engine/dev-guide/media/exception-flow.gif "A diagram that shows the levels from which an excp")
3838

3939
The diagram shows the flow of exceptions through the layers of the application.
4040

4141
## Example
42-
To use any code example that is provided, you will have to choose the programming environment, the programming template, and the programming language in which to create your application. For more information, see [Create a Visual C# SMO Project in Visual Studio .NET](../../relational-databases/server-management-objects-smo/how-to-create-a-visual-csharp-smo-project-in-visual-studio-net.md) or [Create a Visual Basic SMO Project in Visual Studio .NET](../../../2014/database-engine/dev-guide/create-a-visual-basic-smo-project-in-visual-studio-net.md).
42+
To use any code example that is provided, you will have to choose the programming environment, the programming template, and the programming language in which to create your application. For more information, see [Create a Visual C# SMO Project in Visual Studio .NET](../how-to-create-a-visual-csharp-smo-project-in-visual-studio-net.md) or [Create a Visual Basic SMO Project in Visual Studio .NET](../../../database-engine/dev-guide/create-a-visual-basic-smo-project-in-visual-studio-net.md).
4343

4444
## Catching an Exception in Visual Basic
4545
This code example shows how to use the `Try…Catch…Finally`[!INCLUDE[vbprvb](../../../includes/vbprvb-md.md)] statement to catch a SMO exception. All SMO exceptions have the type SmoException, and are listed in the SMO reference. The sequence of inner exceptions is displayed to show the root of the error. For more information, see the [!INCLUDE[vbprvb](../../../includes/vbprvb-md.md)] .NET documentation.

‎docs/2014/relational-databases/server-management-objects-smo/overview-smo.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -41,7 +41,7 @@ manager: "jhubbard"
4141

4242
SMO also represents as new objects or properties many features and components that were introduced in [!INCLUDE[ssVersion2005](../../includes/ssversion2005-md.md)]. These new features and components include the following:
4343

44-
- Table and index partitioning for storage of data on a partition scheme. For more information, see [Partitioned Tables and Indexes](../../database-engine/indexes.md).
44+
- Table and index partitioning for storage of data on a partition scheme. For more information, see [Partitioned Tables and Indexes](../partitions/partitioned-tables-and-indexes.md).
4545

4646
- HTTP endpoints for managing SOAP requests. For more information, see [Implementing Endpoints](tasks/implementing-endpoints.md).
4747

@@ -55,11 +55,11 @@ manager: "jhubbard"
5555

5656
- Synonym support for multiple names of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database objects. For more information, see [Synonyms (Database Engine)](../synonyms/synonyms-database-engine.md).
5757

58-
- The management of Database Mail that lets you create e-mail servers, e-mail profiles, and e-mail accounts in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. For more information, see [Database Mail](../../database-engine/dev-guide/database-mail.md).
58+
- The management of Database Mail that lets you create e-mail servers, e-mail profiles, and e-mail accounts in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. For more information, see [Database Mail](../database-mail/database-mail.md).
5959

6060
- Registered Servers support for registering connection information. For more information, see [Register Servers](../../database-engine/register-servers.md).
6161

62-
- Trace and replay of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] events. For more information, see [SQL Server Profiler](../../analysis-services/instances/sql-server-profiler.md), [SQL Trace](../sql-trace/sql-trace.md), [SQL Server Distributed Replay](../../database-engine/sql-server-distributed-replay.md), and [Extended Events](../../analysis-services/instances/extended-events.md).
62+
- Trace and replay of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] events. For more information, see [SQL Server Profiler](../../database-engine/sql-server-profiler.md), [SQL Trace](../sql-trace/sql-trace.md), [SQL Server Distributed Replay](../../database-engine/sql-server-distributed-replay.md), and [Extended Events](../extended-events/extended-events.md).
6363

6464
- Support for certificates and keys for security control. For more information, see [Encryption Hierarchy](../security/encryption/encryption-hierarchy.md).
6565

‎docs/2014/relational-databases/server-management-objects-smo/tasks/programming-specific-tasks.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -42,12 +42,12 @@ manager: "jhubbard"
4242
|[Backing Up and Restoring Databases and Transaction Logs](backing-up-and-restoring-databases-and-transaction-logs.md)|Describes how to back up and restore databases and transaction logs in SMO.|
4343
|[Scripting](scripting.md)|Describes how to script objects and discover dependencies between objects in SMO.|
4444
|[Transferring Data](transferring-data.md)|Describes how to transfer data in SMO.|
45-
|[Using Database Mail](../../../database-engine/dev-guide/database-mail.md)|Describes how SMO makes use of e-mail services.|
45+
|[Using Database Mail](using-database-mail.md)|Describes how SMO makes use of e-mail services.|
4646
|[Managing Service Broker](managing-service-broker.md)|Describes how to set up Service Broker using SMO.|
4747
|[Using XML Schemas](using-xml-schemas.md)|Describes how to use the XML data type in SMO.|
4848
|[Using Synonyms](using-synonyms.md)|Describes how to create synonyms in SMO.|
4949
|[Using Messages](using-messages.md)|Describes how to use system messages, and how to define your own user-defined messages.|
50-
|[Implementing Full-Text Search](../../../database-engine/full-text-search.md)|Describes how to implement full-text search catalogs and indexes in SMO.|
50+
|[Implementing Full-Text Search](implementing-full-text-search.md)|Describes how to implement full-text search catalogs and indexes in SMO.|
5151
|[Implementing Endpoints](implementing-endpoints.md)|Describes how to create endpoints to handle payloads for Database Mirroring, SOAP requests, and Service Broker.|
5252
|[Creating and Updating Statistics](../../statistics/statistics.md)|Describes how to set up and monitor statistics on a database in SMO.|
5353
|[Tracing and Replaying Events](tracing-and-replaying-events.md)|Describes how to use the `Trace` and `Replay` objects in SMO to trace and replay events.|

‎docs/2014/relational-databases/server-management-objects-smo/tasks/scheduling-automatic-administrative-tasks-in-sql-server-agent.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -280,7 +280,7 @@ pa.AddSubSystem(AgentSubSystem.CmdExec);
280280
```
281281

282282
## See Also
283-
[SQL Server Agent](../../../analysis-services/instances/sql-server-agent.md)
283+
[SQL Server Agent](../../../database-engine/sql-server-agent.md)
284284
[Implement Jobs](../../../database-engine/implement-jobs.md)
285285

286286

‎docs/2014/relational-databases/server-management-objects-smo/tasks/tracing-and-replaying-events.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -50,7 +50,7 @@ manager: "jhubbard"
5050

5151
- Replay trace files or trace tables.
5252

53-
The trace data from the `Trace` and `Replay` objects can be used by the SMO application, or it can be examined manually by using [SQL Server Profiler](../../../analysis-services/instances/sql-server-profiler.md). The trace data is also compatible with the [SQL Trace](../../sql-trace/sql-trace.md) stored procedures that also provide tracing capabilities.
53+
The trace data from the `Trace` and `Replay` objects can be used by the SMO application, or it can be examined manually by using [SQL Server Profiler](../../../database-engine/sql-server-profiler.md). The trace data is also compatible with the [SQL Trace](../../sql-trace/sql-trace.md) stored procedures that also provide tracing capabilities.
5454

5555
The SMO trace objects reside in the <xref:Microsoft.SqlServer.Management.Trace> namespace, which requires a reference to the Microsoft.SQLServer.ConnectionInfo.dll file.
5656

‎docs/2014/relational-databases/server-management-objects-smo/tasks/using-table-and-index-partitioning.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ ms.author: "jhubbard"
2222
manager: "jhubbard"
2323
---
2424
# Using Table and Index Partitioning
25-
Data can be stored by using the storage algorithms provided by [Partitioned Tables and Indexes](../../../database-engine/indexes.md). Partitioning can make large tables and indexes more manageable and scalable.
25+
Data can be stored by using the storage algorithms provided by [Partitioned Tables and Indexes](../partitions/partitioned-tables-and-indexes.md). Partitioning can make large tables and indexes more manageable and scalable.
2626

2727
## Index and Table Partitioning
2828
The feature enables index and table data to be spread across multiple file groups in partitions. A partition function defines how the rows of a table or index are mapped to a set of partitions based on the values of certain columns, referred to as partitioning columns. A partition scheme maps each partition specified by the partition function to a file group. This lets you develop archiving strategies that enable tables to be scaled across file groups, and therefore physical devices.
@@ -134,6 +134,6 @@ $ps.Create()
134134
```
135135

136136
## See Also
137-
[Partitioned Tables and Indexes](../../../database-engine/indexes.md)
137+
[Partitioned Tables and Indexes](../partitions/partitioned-tables-and-indexes.md)
138138

139139

‎docs/2014/relational-databases/service-broker/configure-dialog-security-for-event-notifications.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -87,7 +87,7 @@ manager: "jhubbard"
8787
[GRANT &#40;Transact-SQL&#41;](~/t-sql/statements/grant-transact-sql.md)
8888
[BACKUP CERTIFICATE &#40;Transact-SQL&#41;](~/t-sql/statements/backup-certificate-transact-sql.md)
8989
[sys.databases &#40;Transact-SQL&#41;](~/relational-databases/system-catalog-views/sys-databases-transact-sql.md)
90-
[Encryption Hierarchy](../relational-databases/security/encryption/encryption-hierarchy.md)
90+
[Encryption Hierarchy](../security/encryption/encryption-hierarchy.md)
9191
[Implement Event Notifications](event-notifications.md)
9292
[CREATE MASTER KEY &#40;Transact-SQL&#41;](~/t-sql/statements/create-master-key-transact-sql.md)
9393
[CREATE LOGIN &#40;Transact-SQL&#41;](~/t-sql/statements/create-login-transact-sql.md)

0 commit comments

Comments
 (0)