syspolicy_conditions (Transact-SQL)
Wyświetla jeden wiersz dla każdego warunku Zarządzania opartego na zasadach w wystąpieniu programu SQL Server.Widok syspolicy_conditions należy do schematu dbo w bazie danych msdb.W poniższej tabeli opisano kolumny widoku syspolicy_conditions.
Nazwa kolumna |
Typ danych |
Description |
|---|---|---|
condition_id |
int |
A local temporary procedure is visible only to the connection that created it.A global temporary procedure is available to all connections. |
Nazwa |
sysname |
Local temporary procedures are automatically dropped at the end of the current session. |
date_created |
datetime |
Global temporary procedures are dropped at the end of the last session using the procedure. |
Opis |
nvarchar(max) |
Automatically Executing Stored ProceduresA column name is required only when a column is derived from an arithmetic expression, a function, or a constant; when two or more columns may otherwise have the same name, typically because of a join; or when a column in a view is specified a name different from that of the column from which it is derived. |
A view can be created that uses more than one table or other views with a SELECT clause of any complexity. |
sysname |
Nazwa logowania użytkownika, który utworzył warunek. |
modified_by |
sysname |
Nazwa logowania użytkownika, który ostatnio modyfikował warunek.Ma wartość NULL, jeśli nigdy nie był modyfikowany. |
date_modified |
datetime |
Global temporary procedures are dropped at the end of the last session using the procedure.An ORDER BY clause, unless there is also a TOP clause in the select list of the SELECT statement |
is_name_condition |
smallint |
Stored Procedure Nesting Stored procedures can be nested. This means one stored procedure can call another. |
zestaw reguł |
nvarchar(max) |
The nesting level is incremented when the called procedure starts running, and decremented when the called procedure finishes running. |
Expression |
nvarchar(max) |
Stored procedures can be nested up to 32 levels. |
obj_name |
sysname |
Performance Monitor object name |
Remarks
Performance Monitor Counter name
Uprawnienia
Wymaga członkostwo w roli PolicyAdministratorRole bazy danych msdb.