Skip to content

Commit 64e40ae

Browse files
DCtheGeekDCtheGeek
committed
Links: SQL - ssms - 0
1 parent 12d1151 commit 64e40ae

50 files changed

Lines changed: 119 additions & 168 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/ssms/administer-servers-with-sql-server-management-studio.md‎

Lines changed: 3 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ ms.author: "maghan"
2222
The tool components of [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window. To display a tool, on the **View** menu, click the tool name. To display the Query Editor tool, click the **New Query** button on the toolbar.
2323

2424
> [!IMPORTANT]
25-
> Network traffic between [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] and [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] is unencrypted by default. Do not work with sensitive data (including passwords) in [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] unless you have established an encrypted connection. For more information, see [How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)](https://msdn.microsoft.com/e1e55519-97ec-4404-81ef-881da3b42006).
25+
> Network traffic between [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] and [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] is unencrypted by default. Do not work with sensitive data (including passwords) in [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] unless you have established an encrypted connection. For more information, see [How to: Enable Encrypted Connections to the Database Engine (SQL Server Configuration Manager)](../database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine.md).
2626
2727
Use [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] to:
2828

@@ -55,6 +55,5 @@ Use [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] to:
5555
To start and stop [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] or [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] Agent, use [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] Configuration Manager.
5656

5757
## See Also
58-
[Use SQL Server Management Studio](../ssms/use-sql-server-management-studio.md)
59-
[How to: View server properties (SQL Server Management Studio)](https://msdn.microsoft.com/55f3ac04-5626-4ad2-96bd-a1f1b079659d)
60-
58+
[Use SQL Server Management Studio](./sql-server-management-studio-ssms.md)
59+
[How to: View server properties (SQL Server Management Studio)](../database-engine/configure-windows/view-or-change-server-properties-sql-server.md)

‎docs/ssms/agent/alert-properties-history-page.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
2020

2121

2222
> [!IMPORTANT]
23-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
23+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2424
2525

2626
Use this page to view and modify the history of [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent alerts.
@@ -40,4 +40,3 @@ Reset the information on this page.
4040

4141
## See Also
4242
[Alerts](../../ssms/agent/alerts.md)
43-

‎docs/ssms/agent/alert-properties-new-alert-general-page.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
2020

2121

2222
> [!IMPORTANT]
23-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
23+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2424
2525
Use this page to view and modify the general properties of [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent alerts.
2626

@@ -84,4 +84,3 @@ Specify the WQL statement that identifies the event that the alert responds to.
8484
[Using WQL with the WMI Provider for Server Events](../../relational-databases/wmi-provider-server-events/using-wql-with-the-wmi-provider-for-server-events.md)
8585
[Create an Alert Using an Error Number](../../ssms/agent/create-an-alert-using-an-error-number.md)
8686
[Create an Alert Using Severity Level](../../ssms/agent/create-an-alert-using-severity-level.md)
87-

‎docs/ssms/agent/alert-properties-new-alert-options-page.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
1919
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
2020

2121
> [!IMPORTANT]
22-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
22+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2323
2424
Use this page to view and modify options for [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent alerts.
2525

@@ -47,4 +47,3 @@ Specify a delay in seconds. To respond every time the event occurs, specify 0 mi
4747

4848
## See Also
4949
[Alerts](../../ssms/agent/alerts.md)
50-

‎docs/ssms/agent/alert-properties-new-alert-response-page.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
1919
[!INCLUDE [SQL Server SQL MI](../../includes/applies-to-version/sql-asdbmi.md)]
2020

2121
> [!IMPORTANT]
22-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
22+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2323
2424
Use this page to specify a job that you want to run and to obtain a list of operators to be notified in response to a [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent alert.
2525

@@ -60,4 +60,3 @@ Displays the **Properties** dialog box for the currently selected operator. You
6060
[Alerts](../../ssms/agent/alerts.md)
6161
[Edit an Alert](../../ssms/agent/edit-an-alert.md)
6262
[Delete an Alert](../../ssms/agent/delete-an-alert.md)
63-

‎docs/ssms/agent/alerts-node-sql-server-agent-f1-help.md‎

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -17,8 +17,6 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
1717
[!INCLUDE [SQL Server SQL MI](../../includes/applies-to-version/sql-asdbmi.md)]
1818

1919
> [!IMPORTANT]
20-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
20+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2121
2222
This section contains the F1 Help for the **Alerts** node of Object Explorer in [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)].
23-
24-

‎docs/ssms/agent/alerts.md‎

Lines changed: 10 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
3131
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
3232

3333
> [!IMPORTANT]
34-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
34+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
3535
3636
Events are generated by [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] and entered into the [!INCLUDE[msCoName](../../includes/msconame_md.md)] Windows application log. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent reads the application log and compares events written there to alerts that you have defined. When [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent finds a match, it fires an alert, which is an automated response to an event. In addition to monitoring [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] events, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent can also monitor performance conditions and Windows Management Instrumentation (WMI) events.
3737

@@ -125,44 +125,43 @@ Following are links to common tasks:
125125

126126
- [SQL Server Management Studio](../../ssms/agent/create-an-alert-using-an-error-number.md)
127127

128-
- [Transact-SQL](https://msdn.microsoft.com/d9b41853-e22d-4813-a79f-57efb4511f09)
128+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-add-alert-transact-sql.md)
129129

130130
**To create an alert based on severity levels**
131131

132132
- [SQL Server Management Studio](../../ssms/agent/create-an-alert-using-severity-level.md)
133133

134-
- [Transact-SQL](https://msdn.microsoft.com/d9b41853-e22d-4813-a79f-57efb4511f09)
134+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-add-alert-transact-sql.md)
135135

136136
**To create an alert based on a WMI event**
137137

138138
- [SQL Server Management Studio](../../ssms/agent/create-a-wmi-event-alert.md)
139139

140-
- [Transact-SQL](https://msdn.microsoft.com/d9b41853-e22d-4813-a79f-57efb4511f09)
140+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-add-alert-transact-sql.md)
141141

142142
**To define the response to an alert**
143143

144144
- [SQL Server Management Studio](../../ssms/agent/define-the-response-to-an-alert-sql-server-management-studio.md)
145145

146-
- [Transact-SQL](https://msdn.microsoft.com/0525e0a2-ed0b-4e69-8a4c-a9e3e3622fbd)
146+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-add-notification-transact-sql.md)
147147

148148
**To create a user-defined event error message**
149149

150-
- [Transact-SQL](https://msdn.microsoft.com/54746d30-f944-40e5-a707-f2d9be0fb9eb)
150+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-addmessage-transact-sql.md)
151151

152152
**To modify a user-defined event error message**
153153

154-
- [Transact-SQL](https://msdn.microsoft.com/1b28f280-8ef9-48e9-bd99-ec14d79abaca)
154+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-altermessage-transact-sql.md)
155155

156156
**To delete a user-defined event error message**
157157

158-
- [Transact-SQL](https://msdn.microsoft.com/17287a15-cdde-43d1-bb18-9f920bc15db8)
158+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-dropmessage-transact-sql.md)
159159

160160
**To disable or reactivate an alert**
161161

162162
- [SQL Server Management Studio](../../ssms/agent/disable-or-reactivate-an-alert.md)
163163

164-
- [Transact-SQL](https://msdn.microsoft.com/4bbaeaab-8aca-4c9e-abc1-82ce73090bd3)
164+
- [Transact-SQL](../../relational-databases/system-stored-procedures/sp-update-alert-transact-sql.md)
165165

166166
## See Also
167-
[sp_update_alert (Transact-SQL)](https://msdn.microsoft.com/bcd731b1-3c4e-4086-b58a-af7a3af904ad)
168-
167+
[sp_update_alert (Transact-SQL)](../../relational-databases/performance-monitor/use-sql-server-objects.md)

‎docs/ssms/agent/assign-a-job-to-a-job-category.md‎

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -26,7 +26,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
2626
[!INCLUDE [SQL Server SQL MI](../../includes/applies-to-version/sql-asdbmi.md)]
2727

2828
> [!IMPORTANT]
29-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
29+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
3030
3131
This topic describes how to assign [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent jobs to job categories in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)], [!INCLUDE[tsql](../../includes/tsql-md.md)] or SQL Server Management Objects.
3232

@@ -73,10 +73,9 @@ For detailed information, see [Implement SQL Server Agent Security](../../ssms/a
7373
GO
7474
```
7575

76-
For more information, see [sp_update_job (Transact-SQL)](https://msdn.microsoft.com/cbdfea38-9e42-47f3-8fc8-5978b82e2623).
76+
For more information, see [sp_update_job (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-update-job-transact-sql.md).
7777

7878
## <a name="SMO"></a>Using SQL Server Management Objects
7979
**To assign a job to a job category**
8080

8181
Use the **JobCategory** class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell.
82-

‎docs/ssms/agent/assign-alerts-to-an-operator.md‎

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
2525
[!INCLUDE [SQL Server SQL MI](../../includes/applies-to-version/sql-asdbmi.md)]
2626

2727
> [!IMPORTANT]
28-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
28+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
2929
3030
This topic describes how to assign [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent alerts to operators so they can receive notifications about jobs in [!INCLUDE[ssCurrent](../../includes/sscurrent-md.md)] by using [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] or [!INCLUDE[tsql](../../includes/tsql-md.md)].
3131

@@ -86,5 +86,4 @@ Only members of the **sysadmin** fixed server role can assign alerts to operator
8686
GO
8787
```
8888
89-
For more information, see [sp_add_notification (Transact-SQL)](https://msdn.microsoft.com/0525e0a2-ed0b-4e69-8a4c-a9e3e3622fbd).
90-
89+
For more information, see [sp_add_notification (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-add-notification-transact-sql.md).

‎docs/ssms/agent/automated-administration-across-an-enterprise.md‎

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,7 @@ monikerRange: "= azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts
2727
[!INCLUDE [SQL Server SQL MI](../../includes/applies-to-version/sql-asdbmi.md)]
2828

2929
> [!IMPORTANT]
30-
> On [Azure SQL Managed Instance](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](https://docs.microsoft.com/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
30+
> On [Azure SQL Managed Instance](/azure/sql-database/sql-database-managed-instance), most, but not all SQL Server Agent features are currently supported. See [Azure SQL Managed Instance T-SQL differences from SQL Server](/azure/sql-database/sql-database-managed-instance-transact-sql-information#sql-server-agent) for details.
3131
3232
Automating administration across multiple instances of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] is called *multiserver administration*. Use multiserver administration to do the following:
3333

@@ -80,7 +80,7 @@ Contains information about event forwarding from target servers to master server
8080
Contains information about how automated administration in a multiserver environment takes advantage of the self-tuning features of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
8181

8282
## See Also
83-
[Backward Compatibility Topics for Installing the SQL Server Database Engine](../../database-engine/sql-server-database-engine-backward-compatibility.md)
83+
[Backward Compatibility Topics for Installing the SQL Server Database Engine](../../database-engine/discontinued-database-engine-functionality-in-sql-server.md)
8484
[Registering Servers](../register-servers/register-servers.md)
8585
[sp_add_targetservergroup](../../relational-databases/system-stored-procedures/sp-add-targetservergroup-transact-sql.md)
8686
[sp_delete_targetserver](../../relational-databases/system-stored-procedures/sp-delete-targetserver-transact-sql.md)
@@ -93,4 +93,3 @@ Contains information about how automated administration in a multiserver environ
9393
[sysjobservers](../../relational-databases/system-tables/dbo-sysjobservers-transact-sql.md)
9494
[syslogins](../../relational-databases/system-compatibility-views/sys-syslogins-transact-sql.md)
9595
[systargetservers](../../relational-databases/system-tables/dbo-systargetservers-transact-sql.md)
96-

0 commit comments

Comments
 (0)