| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Windows/Microsoft.NET/Framework64/v4.0.30319/SQL/en/ |
Upload File : |
set ansi_nulls on
set quoted_identifier on
set nocount on
go
if exists (select * from sys.views where object_id = object_id(N'[System.Activities.DurableInstancing].[Instances]'))
drop view [System.Activities.DurableInstancing].[Instances]
go
if exists (select * from sys.views where object_id = object_id(N'[System.Activities.DurableInstancing].[ServiceDeployments]'))
drop view [System.Activities.DurableInstancing].[ServiceDeployments]
go
if exists (select * from sys.views where object_id = object_id(N'[System.Activities.DurableInstancing].[InstancePromotedProperties]'))
drop view [System.Activities.DurableInstancing].[InstancePromotedProperties]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[InstancesTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[InstancesTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[RunnableInstancesTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[RunnableInstancesTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[KeysTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[KeysTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[LockOwnersTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[LockOwnersTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[InstanceMetadataChangesTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[InstanceMetadataChangesTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[ServiceDeploymentsTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[ServiceDeploymentsTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[InstancePromotedPropertiesTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[InstancePromotedPropertiesTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[SqlWorkflowInstanceStoreVersionTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[SqlWorkflowInstanceStoreVersionTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[IdentityOwnerTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[IdentityOwnerTable]
go
if exists (select * from sys.objects where object_id = object_id(N'[System.Activities.DurableInstancing].[DefinitionIdentityTable]') and type in (N'U'))
drop table [System.Activities.DurableInstancing].[DefinitionIdentityTable]
go
if exists (select * from sys.schemas where name = N'System.Activities.DurableInstancing')
exec ('drop schema [System.Activities.DurableInstancing]')
go
if exists (select 1 from [dbo].[sysusers] where name=N'System.Activities.DurableInstancing.InstanceStoreUsers' and issqlrole=1 )
drop role [System.Activities.DurableInstancing.InstanceStoreUsers]
go
if exists (select 1 from [dbo].[sysusers] where name=N'System.Activities.DurableInstancing.WorkflowActivationUsers' and issqlrole=1 )
drop role [System.Activities.DurableInstancing.WorkflowActivationUsers]
go
if exists (select 1 from [dbo].[sysusers] where name=N'System.Activities.DurableInstancing.InstanceStoreObservers' and issqlrole=1 )
drop role [System.Activities.DurableInstancing.InstanceStoreObservers]
go