Home → Disable/Enable Logins P7 → Disable client log-ins in P7 → Disable Dataset in P7

1.1. Disable Dataset in P7

--Replace Database name and replace '1' - '0' to reactive.

declare @rowcount int
declare @dtbname varchar(200)
declare @intflag int
declare @clientguid uniqueidentifier
declare @dtbguid uniqueidentifier
set @dtbname='P7_SAFEPAC_12302014'
set @intFlag=1
select dtb_GUID,dtb_cli_guid,rowid=ROW_NUMBER() over (order by dtb_cli_guid) into #temp from Security7..sec7_Database where dtb_Name=@dtbname

select @rowcount=count(dtb_cli_guid) from #temp
WHILE (@intFlag <=@rowcount)
BEGIN
select @clientguid=dtb_cli_guid from #temp where rowid=@intflag
select @dtbguid=dtb_GUID from #temp where rowid=@intflag

--delete from Security7..sec7_Referral where ref_dtb_GUID=@dtbguid
--delete from Security7..sec7_Database where dtb_cli_GUID=@clientguid
--delete from Security7..sec7_Operator where opr_cli_GUID=@clientguid
--delete from Security7..sec7_Client where cli_GUID =@clientguid

update Security7..sec7_Referral set ref_deleted=1 where ref_dtb_GUID=@dtbguid
update Security7..sec7_Database set dtb_deleted=1 where dtb_cli_GUID=@clientguid
update Security7..sec7_Operator set opr_deleted=1 where opr_cli_GUID=@clientguid
update Security7..sec7_Client set cli_deleted=1 where cli_GUID =@clientguid

set @intFlag=@intFlag+1
End
drop table #temp