SqlDependency.Stop Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| Stop(String) |
Stops a listener for a connection specified in a previous Start(String) call. |
| Stop(String, String) |
Stops a listener for a connection specified in a previous Start(String, String) call. |
Stop(String)
Stops a listener for a connection specified in a previous Start(String) call.
public:
static bool Stop(System::String ^ connectionString);public static bool Stop (string connectionString);static member Stop : string -> boolPublic Shared Function Stop (connectionString As String) As BooleanParameters
- connectionString
- String
Connection string for the instance of SQL Server that was used in a previous Start(String) call.
Returns
true if the listener was completely stopped; false if the AppDomain was unbound from the listener, but there are is at least one other AppDomain using the same listener.
Exceptions
The connectionString parameter is NULL.
The method was called from within SQLCLR.
The caller does not have the required SqlClientPermission code access security (CAS) permission.
An underlying SqlClient exception occurred.
Remarks
The Stop method must be called for each Start call. A given listener only shuts down fully when it receives the same number of Stop requests as Start requests.
Applies to
Stop(String, String)
Stops a listener for a connection specified in a previous Start(String, String) call.
public:
static bool Stop(System::String ^ connectionString, System::String ^ queue);public static bool Stop (string connectionString, string queue);static member Stop : string * string -> boolPublic Shared Function Stop (connectionString As String, queue As String) As BooleanParameters
- connectionString
- String
Connection string for the instance of SQL Server that was used in a previous Start(String, String) call.
- queue
- String
The SQL Server Service Broker queue that was used in a previous Start(String, String) call.
Returns
true if the listener was completely stopped; false if the AppDomain was unbound from the listener, but there is at least one other AppDomain using the same listener.
Exceptions
The connectionString parameter is NULL.
The method was called from within SQLCLR.
The caller does not have the required SqlClientPermission code access security (CAS) permission.
And underlying SqlClient exception occurred.
Remarks
The Stop method must be called for each Start call. A given listener only shuts down fully when it receives the same number of Stop requests as Start requests.