[dbo].[ClearScheduleConsistancyFlags]

(local) > ReportServer > Stored Procedures > dbo.ClearScheduleConsistancyFlags

Properties
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Permissions

Type	Action	Owning Principal
Grant	Execute	RSExecRole

SQL Script

CREATE PROCEDURE [dbo].[ClearScheduleConsistancyFlags]
AS
update [Schedule] with (tablock, xlock) set [ConsistancyCheck] = NULL

GO
GRANT EXECUTE ON [dbo].[ClearScheduleConsistancyFlags] TO [RSExecRole]
GO

Uses

[dbo].[Schedule]
dbo