Database

				
					USE [master]
GO

DECLARE @dbname_holder VARCHAR(1000)

DECLARE Cur_dbOwnerRename CURSOR
FOR
 SELECT [name]  FROM sysdatabases where name like 'ApAdmin%' or name like 'ApPublic%' or name like 'Apops%' 
 or name like 'ApReports%' or name like 'ApJournal%' or name like 'APENT_TicketDesk%'

OPEN Cur_dbOwnerRename
FETCH NEXT FROM Cur_dbOwnerRename INTO @dbname_holder

WHILE (@@FETCH_STATUS <> -1)
BEGIN

 exec('ALTER DATABASE [' + @dbname_holder + '] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE')

 exec('DROP DATABASE [' + @dbname_holder + ']')

FETCH NEXT FROM Cur_dbOwnerRename INTO @dbname_holder
END 

CLOSE Cur_dbOwnerRename
DEALLOCATE Cur_dbOwnerRename
GO



DECLARE @name_holder VARCHAR(1000)

DECLARE Cur_JobOwnerRename CURSOR
FOR
 SELECT [name]  FROM msdb..sysjobs where-- [name]!='syspolicy_purge_history'
  [name] in ('Job_UserSessionIdleTimeout', 'Job_StaleEnrollmentArchieve', 'RC_Job_DataLoad_RCSS_1', 'RC_Job_DataLoad_Zone_2',
				'RC_Job_InsertActiveUsers', 'RC_Job_InsertConcurrentUsers', 'RC_Job_InsertConcurrentSessions', 'RC_Job_InsertSessionStatusDetails',
				'JobScheduler_ArchieveENTIncident', 'IdleMutiTenantCreationJob', 'Multitenant_Job_ReportSummary', 'Multitenant_Job_DeviceLifeCycleState'
				)
OPEN Cur_JobOwnerRename
FETCH NEXT FROM Cur_JobOwnerRename INTO @name_holder

WHILE (@@FETCH_STATUS <> -1)
BEGIN
exec msdb..sp_delete_job
        @job_name = @name_holder

FETCH NEXT FROM Cur_JobOwnerRename INTO @name_holder
END 

CLOSE Cur_JobOwnerRename
DEALLOCATE Cur_JobOwnerRename

IF EXISTS(SELECT name FROM [master].[sys].[syslogins] WHERE NAME = 'apadminuser')
BEGIN 
DROP LOGIN apadminuser
END

GO

IF EXISTS(SELECT name FROM [master].[sys].[syslogins] WHERE NAME = 'apdbuser')
BEGIN 
DROP LOGIN apdbuser
END

GO

use [msdb]
go
IF EXISTS(select 1 from sys.sysusers where name = 'apadminuser')
DROP user [apadminuser]
GO
IF EXISTS(select 1 from sys.sysusers where name = 'apdbuser')
DROP USER [apdbuser]

GO