Database.ValidateAllPlanGuides Method ()
Verifies the validity of the execution plans associated with the database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
Public Function ValidateAllPlanGuides As Boolean
public bool ValidateAllPlanGuides ()
public:
bool ValidateAllPlanGuides ()
public boolean ValidateAllPlanGuides ()
public function ValidateAllPlanGuides () : boolean
Return Value
A Boolean value that determines whether all of the execution plans are valid.
Remarks
If the method is unsuccessful, you can run the method again with the output parameter that contains detailed information about each execution plan.
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
See Also
Reference
Database Class
Database Members
Microsoft.SqlServer.Management.Smo Namespace
sys.fn_validate_plan (Transact-SQL)