USE [Actions02_Def]
GO

DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

IF NOT EXISTS ( SELECT * FROM [dbo].[tblMacros] WHERE ID=100 ) 
	INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL);

IF NOT EXISTS ( SELECT * FROM [dbo].[tblMacros] WHERE ID=101 ) 
	INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)

IF NOT EXISTS ( SELECT * FROM [dbo].[tblMacros] WHERE ID=102 ) 
	INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [AppraisalSections02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Appraisals02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [BugTrk02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [ChangeRequests02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Configuration02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [HelpDesk02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)
GO


/******** *************/
USE [Installations02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [InventoriedSoftware02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [KnowledgeBase02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [LicenseManager02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Purchases&Agreements02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [ReleaseMgmt02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Resources02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Roles02_Def]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)

/******** *************/
USE [Users_mdb]
GO
DELETE FROM [tblMacros] WHERE tName='<Is Accessible Department>' OR
	tName='<Is Accessible Location>'  OR
	tName='<Is Accessible Company>'  OR
	tName='<Is Accessible Organization>' OR
	tName='<Director IT Business Solutions>' OR
	tName='<Director IT Infrastructure>' OR
	tName='<Director IT Services>' OR
	tName='<Director IT Security>' OR
	tName='<Senior Systems Analyst>'
	
GO

INSERT INTO [dbo].[tblMacros] VALUES (100, N'<Is Accessible Department>', N'IsAccessibleDepartment', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (101, N'<Is Accessible Location>', N'IsAccessibleLocation', NULL, 2, 0, NULL, NULL)
INSERT INTO [dbo].[tblMacros] VALUES (102, N'<Is Accessible Organization>', N'IsAccessibleCompany', NULL, 2, 0, NULL, NULL)
