All of my users are complaning that they do not get their registration emails. I even tried to choose the "Forgot Password" and this was unsuccessful. I ran a check on the database and (dont know if its related) this is what it showed.
================ please wait... Found tblQuarantine Found tblMsgs Found tblRejectCodes Found tblLogins Found tblServers tbl_FilterSettingsPresent - not found tbl_LocalDomainsPresent - not found tblBL_AttachmentsPresent - not found tblBL_CountriesPresent - not found tblBL_DomainsPresent - not found tblBL_EmailsFromPresent - not found tblBL_EmailsToPresent - not found tblBL_HoneypotblockedIPsPresent - not found tblBL_HoneypotEmailsPresent - not found tblBL_IPsPresent - not found tblBL_KeywordsPresent - not found tblBL_MAPSPresent - not found tblBL_SURBLPresent - not found tblReloadTableInfoPresent - not found tblWL_AuthorizedTOEmailsPresent - not found tblWL_AutoWhitelistForceDeliveryPresent - not found tblWL_DomainsIPsPresent - not found tblWL_EmailsFromPresent - not found tblWL_EmailsToPresent - not found tblWL_KeywordsPresent - not found Some Enterprise Database tables not found - recreating... ===========Executing:============ -- if exists (select * from sysobjects where name = 'tblbl_domains') drop table [dbo].[tblbl_domains] create table [dbo].[tblbl_domains] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [domainname] varchar(255), constraint [pk_tblbl_domains_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_emailsfrom') drop table [dbo].[tblbl_emailsfrom] create table [dbo].[tblbl_emailsfrom] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblbl_emailsfrom_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_emailsto') drop table [dbo].[tblbl_emailsto] create table [dbo].[tblbl_emailsto] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblbl_emailsto_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_maps') drop table [dbo].[tblbl_maps] create table [dbo].[tblbl_maps] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [server] varchar(255), [reverseip] bit default 1, constraint [pk_tblbl_maps_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_keywords') drop table [dbo].[tblbl_keywords] create table [dbo].[tblbl_keywords] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [keywords] varchar(1024), constraint [pk_tblbl_keywords_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_attachments') drop table [dbo].[tblbl_attachments] create table [dbo].[tblbl_attachments] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [attachments] varchar(1024), constraint [pk_tblbl_attachments_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_surbl') drop table [dbo].[tblbl_surbl] create table [dbo].[tblbl_surbl] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [server] varchar(320), constraint [pk_tblbl_surbl_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_ips') drop table [dbo].[tblbl_ips] create table [dbo].[tblbl_ips] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [ip] varchar(15), constraint [pk_tblbl_ips_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_honeypotemails') drop table [dbo].[tblbl_honeypotemails] create table [dbo].[tblbl_honeypotemails] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblbl_honeypotemails_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_honeypotblockedips') drop table [dbo].[tblbl_honeypotblockedips] create table [dbo].[tblbl_honeypotblockedips] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [ip] varchar(15), constraint [pk_tblbl_honeypotblockedips_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblbl_countries') drop table [dbo].[tblbl_countries] create table [dbo].[tblbl_countries] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [countrycode] varchar(2), constraint [pk_tblbl_countries_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_authorizedtoemails') drop table [dbo].[tblwl_authorizedtoemails] create table [dbo].[tblwl_authorizedtoemails] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblwl_authorizedtoemails_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_keywords') drop table [dbo].[tblwl_keywords] create table [dbo].[tblwl_keywords] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [keywords] varchar(1024), constraint [pk_tblwl_keywords_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_emailsfrom') drop table [dbo].[tblwl_emailsfrom] create table [dbo].[tblwl_emailsfrom] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblwl_emailsfrom_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_emailsto') drop table [dbo].[tblwl_emailsto] create table [dbo].[tblwl_emailsto] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblwl_emailsto_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_autowhitelistforcedelivery') drop table [dbo].[tblwl_autowhitelistforcedelivery] create table [dbo].[tblwl_autowhitelistforcedelivery] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [email] varchar(320), constraint [pk_tblwl_autowhitelistforcedelivery_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblwl_domainsips') drop table [dbo].[tblwl_domainsips] create table [dbo].[tblwl_domainsips] ( [id] int not null identity, [domainid] int default 0, [loginid] int default 0, [domain_or_ip] varchar(255), constraint [pk_tblwl_domainsips_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tblreloadtableinfo') drop table [dbo].[tblreloadtableinfo] create table [dbo].[tblreloadtableinfo] ( [id] int not null identity, [domainid] int default 0, [tablename] varchar(45), [updatetable] bit default 1, constraint [pk_tblreloadtableinfo_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tbl_filtersettings') drop table [dbo].[tbl_filtersettings] create table [dbo].[tbl_filtersettings] ( [id] int not null identity, [domainid] int default 0, [bl_domainsforcedelete] bit default 0, [bl_emailsfromforcedelete] bit default 0, [bl_emailstoforcedelete] bit default 0, [bl_countriesforcedelete] bit default 0, [bl_mapsforcedelete] bit default 0, [bl_keywordsforcedelete] bit default 0, [bl_attachmentsforcedelete] bit default 0, [bl_surblforcedelete] bit default 0, [bl_ipsforcedelete] bit default 0, [bl_honeypotemailsforcedelete] bit default 0, [rejectnoreverseforcedelete] bit default 0, [rejectnomxforcedelete] bit default 0, [spffilterenableforcedelete] bit default 0, [rejectemptymailfromforcedelete] bit default 0, [rejectsametofromdomainforcedelete] bit default 0, [rejectsametofromforcedelete] bit default 0, [sfdbforcedelete] bit default 0, [maxrcpt_toforcedelete] bit default 0, [authorizedtoforcedelete] bit default 0, [antivirusforcedelete] bit default 0, [imageforcedelete] bit default 0, [surblforcedelete] bit default 0, [bayesianfilterenable] bit default 1, [bayesianforcedelete] bit default 0, [spffilterenable] bit default 1, [spfneutralfilter] bit default 0, [spfsoftfailfilter] bit default 1, [spffailfilter] bit default 1, [allowpercent] bit default 0, [tagspam] bit default 0, [tagspamsubject] bit default 0, [tagspamandquarantine] bit default 0, [rejectnoreverse] bit default 1, [rejectnomx] bit default 1, [rejectemptymailfrom] bit default 0, [rejectsametofrom] bit default 0, [rejectsametofromdomain] bit default 0, [enableipcacheblacklist] bit default 1, [autowhitelistforcedeliveryenabled] bit default 1, [minmaps] int default 1, [maxsubjectspaces] int default 10, [spamimagethreshold] int default 10, [sfdb_networkreliability] int default 3, [sfdb_filtersall] bit default 1, [sfdb_filterslist] varchar(255), constraint [pk_tbl_filtersettings_id] primary key ([id]), ) -- if exists (select * from sysobjects where name = 'tbl_localdomains') drop table [dbo].[tbl_localdomains] create table [dbo].[tbl_localdomains] ( [id] int not null identity, [domainname] varchar(255), [destsmtpserver] varchar(255), [destsmtpserverport] int, [usedefaults] bit not null default 1, constraint [pk_tbl_localdomains_id] primary key ([id]), ) create index [domainid] on [dbo].[tblbl_domains]([domainid]) create index [loginid] on [dbo].[tblbl_domains]([loginid]) create index [domainname] on [dbo].[tblbl_domains]([domainname]) create index [domainid] on [dbo].[tblbl_emailsfrom]([domainid]) create index [loginid] on [dbo].[tblbl_emailsfrom]([loginid]) create index [email] on [dbo].[tblbl_emailsfrom]([email]) create index [domainid] on [dbo].[tblbl_emailsto]([domainid]) create index [loginid] on [dbo].[tblbl_emailsto]([loginid]) create index [email] on [dbo].[tblbl_emailsto]([email]) create index [domainid] on [dbo].[tblbl_maps]([domainid]) create index [loginid] on [dbo].[tblbl_maps]([loginid]) create index [server] on [dbo].[tblbl_maps]([server]) create index [domainid] on [dbo].[tblbl_keywords]([domainid]) create index [loginid] on [dbo].[tblbl_keywords]([loginid]) create index [domainid] on [dbo].[tblbl_attachments]([domainid]) create index [loginid] on [dbo].[tblbl_attachments]([loginid]) create index [domainid] on [dbo].[tblbl_surbl]([domainid]) create index [loginid] on [dbo].[tblbl_surbl]([loginid]) create index [server] on [dbo].[tblbl_surbl]([server]) create index [domainid] on [dbo].[tblbl_ips]([domainid]) create index [loginid] on [dbo].[tblbl_ips]([loginid]) create index [ip] on [dbo].[tblbl_ips]([ip]) create index [domainid] on [dbo].[tblbl_honeypotemails]([domainid]) create index [loginid] on [dbo].[tblbl_honeypotemails]([loginid]) create index [email] on [dbo].[tblbl_honeypotemails]([email]) create index [domainid] on [dbo].[tblbl_honeypotblockedips]([domainid]) create index [loginid] on [dbo].[tblbl_honeypotblockedips]([loginid]) create index [ip] on [dbo].[tblbl_honeypotblockedips]([ip]) create index [domainid] on [dbo].[tblbl_countries]([domainid]) create index [loginid] on [dbo].[tblbl_countries]([loginid]) create index [countrycode] on [dbo].[tblbl_countries]([countrycode]) create index [domainid] on [dbo].[tblwl_authorizedtoemails]([domainid]) create index [loginid] on [dbo].[tblwl_authorizedtoemails]([loginid]) create index [email] on [dbo].[tblwl_authorizedtoemails]([email]) create index [domainid] on [dbo].[tblwl_keywords]([domainid]) create index [loginid] on [dbo].[tblwl_keywords]([loginid]) create index [domainid] on [dbo].[tblwl_emailsfrom]([domainid]) create index [loginid] on [dbo].[tblwl_emailsfrom]([loginid]) create index [email] on [dbo].[tblwl_emailsfrom]([email]) create index [domainid] on [dbo].[tblwl_emailsto]([domainid]) create index [loginid] on [dbo].[tblwl_emailsto]([loginid]) create index [email] on [dbo].[tblwl_emailsto]([email]) create index [domainid] on [dbo].[tblwl_autowhitelistforcedelivery]([domainid]) create index [loginid] on [dbo].[tblwl_autowhitelistforcedelivery]([loginid]) create index [email] on [dbo].[tblwl_autowhitelistforcedelivery]([email]) create index [domainid] on [dbo].[tblwl_domainsips]([domainid]) create index [loginid] on [dbo].[tblwl_domainsips]([loginid]) create index [domain_or_ip] on [dbo].[tblwl_domainsips]([domain_or_ip]) create index [tablename] on [dbo].[tblreloadtableinfo]([tablename]) create index [domainid] on [dbo].[tbl_filtersettings]([domainid]) create unique index [domainname] on [dbo].[tbl_localdomains]([domainname]) alter table [dbo].[tblbl_domains] add constraint [fktblbl_domains] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_emailsfrom] add constraint [fktblbl_emailsfrom] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_emailsto] add constraint [fktblbl_emailsto] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_maps] add constraint [fktblbl_maps] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_keywords] add constraint [fktblbl_keywords] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_attachments] add constraint [fktblbl_attachments] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_surbl] add constraint [fktblbl_surbl] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_ips] add constraint [fktblbl_ips] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_honeypotemails] add constraint [fktblbl_honeypotemails] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblbl_honeypotblockedips] add constraint [fktblbl_honeypotblockedips] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_authorizedtoemails] add constraint [fktblwl_authorizedtoemails] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_keywords] add constraint [fktblwl_keywords] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_emailsfrom] add constraint [fktblwl_emailsfrom] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_emailsto] add constraint [fktblwl_emailsto] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_autowhitelistforcedelivery] add constraint [fktblwl_autowhitelistforcedelivery] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade alter table [dbo].[tblwl_domainsips] add constraint [fktblwl_domainsips] foreign key ( [domainid] ) references [dbo].[tbl_localdomains] ( [id] ) on delete cascade
******* Error:There is already an object named 'tblbl_domains' in the database ===========Executing:============
insert into tbl_localdomains (domainname) values (' ALL DOMAINS');
******* Error:Cannot insert duplicate key row in object 'dbo.tbl_localdomains' with unique index 'domainname' ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_localdomains_au' and type = 'tr') drop trigger[tr_localdomains_au]; -- go create trigger [dbo].[tr_localdomains_au] on [dbo].[tbl_localdomains] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.id, 1, 'tbl_localdomains' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.id) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_localdomains_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_localdomains_ai' and type = 'tr') drop trigger[tr_localdomains_ai]; -- go create trigger [dbo].[tr_localdomains_ai] on [dbo].[tbl_localdomains] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.id, 1, 'tbl_localdomains' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.id) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_localdomains_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_localdomains_ad' and type = 'tr') drop trigger[tr_localdomains_ad]; -- go create trigger [dbo].[tr_localdomains_ad] on [dbo].[tbl_localdomains] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.id, 1, 'tbl_localdomains' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.id) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_localdomains_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_localdomains_bd' and type = 'tr') drop trigger[tr_localdomains_bd]; -- go create trigger [dbo].[tr_localdomains_bd] on [dbo].[tbl_localdomains] for delete as declare @domainname varchar(255) select @domainname = domainname from deleted if @domainname = ' ALL DOMAINS' begin raiserror('unable to delete system record for "all domains"', 16, 1) end
******* Error:There is already an object named 'tr_localdomains_bd' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_au' and type = 'tr') drop trigger[trwl_authorizedtoemails_au]; -- go create trigger [dbo].[trwl_authorizedtoemails_au] on [dbo].[tblwl_authorizedtoemails] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_authorizedtoemails' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_authorizedtoemails_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_ai' and type = 'tr') drop trigger[trwl_authorizedtoemails_ai]; -- go create trigger [dbo].[trwl_authorizedtoemails_ai] on [dbo].[tblwl_authorizedtoemails] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_authorizedtoemails' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_authorizedtoemails_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_authorizedtoemails_ad' and type = 'tr') drop trigger[trwl_authorizedtoemails_ad]; -- go create trigger [dbo].[trwl_authorizedtoemails_ad] on [dbo].[tblwl_authorizedtoemails] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_authorizedtoemails' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_authorizedtoemails_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_keywords_au' and type = 'tr') drop trigger[trwl_keywords_au]; -- go create trigger [dbo].[trwl_keywords_au] on [dbo].[tblwl_keywords] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_keywords' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_keywords_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_keywords_ai' and type = 'tr') drop trigger[trwl_keywords_ai]; -- go create trigger [dbo].[trwl_keywords_ai] on [dbo].[tblwl_keywords] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_keywords' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_keywords_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_keywords_ad' and type = 'tr') drop trigger[trwl_keywords_ad]; -- go create trigger [dbo].[trwl_keywords_ad] on [dbo].[tblwl_keywords] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_keywords' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_keywords_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_au' and type = 'tr') drop trigger[trwl_emailsfrom_au]; -- go create trigger [dbo].[trwl_emailsfrom_au] on [dbo].[tblwl_emailsfrom] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsfrom' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsfrom_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_ai' and type = 'tr') drop trigger[trwl_emailsfrom_ai]; -- go create trigger [dbo].[trwl_emailsfrom_ai] on [dbo].[tblwl_emailsfrom] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_emailsfrom' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsfrom_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsfrom_ad' and type = 'tr') drop trigger[trwl_emailsfrom_ad]; -- go create trigger [dbo].[trwl_emailsfrom_ad] on [dbo].[tblwl_emailsfrom] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsfrom' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsfrom_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsto_au' and type = 'tr') drop trigger[trwl_emailsto_au]; -- go create trigger [dbo].[trwl_emailsto_au] on [dbo].[tblwl_emailsto] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsto' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsto_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsto_ai' and type = 'tr') drop trigger[trwl_emailsto_ai]; -- go create trigger [dbo].[trwl_emailsto_ai] on [dbo].[tblwl_emailsto] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_emailsto' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsto_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_emailsto_ad' and type = 'tr') drop trigger[trwl_emailsto_ad]; -- go create trigger [dbo].[trwl_emailsto_ad] on [dbo].[tblwl_emailsto] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_emailsto' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_emailsto_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_domainsips_au' and type = 'tr') drop trigger[trwl_domainsips_au]; -- go create trigger [dbo].[trwl_domainsips_au] on [dbo].[tblwl_domainsips] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_domainsips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_domainsips_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_domainsips_ai' and type = 'tr') drop trigger[trwl_domainsips_ai]; -- go create trigger [dbo].[trwl_domainsips_ai] on [dbo].[tblwl_domainsips] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_domainsips' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_domainsips_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_domainsips_ad' and type = 'tr') drop trigger[trwl_domainsips_ad]; -- go create trigger [dbo].[trwl_domainsips_ad] on [dbo].[tblwl_domainsips] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_domainsips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_domainsips_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_au' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_au]; -- go create trigger [dbo].[trwl_autowhitelistforcedelivery_au] on [dbo].[tblwl_autowhitelistforcedelivery] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_autowhitelistforcedelivery' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_ai' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_ai]; -- go create trigger [dbo].[trwl_autowhitelistforcedelivery_ai] on [dbo].[tblwl_autowhitelistforcedelivery] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblwl_autowhitelistforcedelivery' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trwl_autowhitelistforcedelivery_ad' and type = 'tr') drop trigger[trwl_autowhitelistforcedelivery_ad]; -- go create trigger [dbo].[trwl_autowhitelistforcedelivery_ad] on [dbo].[tblwl_autowhitelistforcedelivery] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblwl_autowhitelistforcedelivery' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trwl_autowhitelistforcedelivery_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_domains_au' and type = 'tr') drop trigger[trbl_domains_au]; -- go create trigger [dbo].[trbl_domains_au] on [dbo].[tblbl_domains] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_domains' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_domains_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_domains_ai' and type = 'tr') drop trigger[trbl_domains_ai]; -- go create trigger [dbo].[trbl_domains_ai] on [dbo].[tblbl_domains] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_domains' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_domains_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_domains_ad' and type = 'tr') drop trigger[trbl_domains_ad]; -- go create trigger [dbo].[trbl_domains_ad] on [dbo].[tblbl_domains] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_domains' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_domains_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_au' and type = 'tr') drop trigger[trbl_emailsfrom_au]; -- go create trigger [dbo].[trbl_emailsfrom_au] on [dbo].[tblbl_emailsfrom] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsfrom' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsfrom_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_ai' and type = 'tr') drop trigger[trbl_emailsfrom_ai]; -- go create trigger [dbo].[trbl_emailsfrom_ai] on [dbo].[tblbl_emailsfrom] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_emailsfrom' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsfrom_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsfrom_ad' and type = 'tr') drop trigger[trbl_emailsfrom_ad]; -- go create trigger [dbo].[trbl_emailsfrom_ad] on [dbo].[tblbl_emailsfrom] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsfrom' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsfrom_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsto_au' and type = 'tr') drop trigger[trbl_emailsto_au]; -- go create trigger [dbo].[trbl_emailsto_au] on [dbo].[tblbl_emailsto] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsto' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsto_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsto_ai' and type = 'tr') drop trigger[trbl_emailsto_ai]; -- go create trigger [dbo].[trbl_emailsto_ai] on [dbo].[tblbl_emailsto] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_emailsto' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsto_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_emailsto_ad' and type = 'tr') drop trigger[trbl_emailsto_ad]; -- go create trigger [dbo].[trbl_emailsto_ad] on [dbo].[tblbl_emailsto] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_emailsto' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_emailsto_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_countries_au' and type = 'tr') drop trigger[trbl_countries_au]; -- go create trigger [dbo].[trbl_countries_au] on [dbo].[tblbl_countries] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_countries' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_countries_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_countries_ai' and type = 'tr') drop trigger[trbl_countries_ai]; -- go create trigger [dbo].[trbl_countries_ai] on [dbo].[tblbl_countries] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_countries' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_countries_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_countries_ad' and type = 'tr') drop trigger[trbl_countries_ad]; -- go create trigger [dbo].[trbl_countries_ad] on [dbo].[tblbl_countries] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_countries' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_countries_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_maps_au' and type = 'tr') drop trigger[trbl_maps_au]; -- go create trigger [dbo].[trbl_maps_au] on [dbo].[tblbl_maps] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_maps' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_maps_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_maps_ai' and type = 'tr') drop trigger[trbl_maps_ai]; -- go create trigger [dbo].[trbl_maps_ai] on [dbo].[tblbl_maps] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_maps' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_maps_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_maps_ad' and type = 'tr') drop trigger[trbl_maps_ad]; -- go create trigger [dbo].[trbl_maps_ad] on [dbo].[tblbl_maps] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_maps' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_maps_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_keywords_au' and type = 'tr') drop trigger[trbl_keywords_au]; -- go create trigger [dbo].[trbl_keywords_au] on [dbo].[tblbl_keywords] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_keywords' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_keywords_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_keywords_ai' and type = 'tr') drop trigger[trbl_keywords_ai]; -- go create trigger [dbo].[trbl_keywords_ai] on [dbo].[tblbl_keywords] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_keywords' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_keywords_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_keywords_ad' and type = 'tr') drop trigger[trbl_keywords_ad]; -- go create trigger [dbo].[trbl_keywords_ad] on [dbo].[tblbl_keywords] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_keywords' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_keywords_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_attachments_au' and type = 'tr') drop trigger[trbl_attachments_au]; -- go create trigger [dbo].[trbl_attachments_au] on [dbo].[tblbl_attachments] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_attachments' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_attachments_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_attachments_ai' and type = 'tr') drop trigger[trbl_attachments_ai]; -- go create trigger [dbo].[trbl_attachments_ai] on [dbo].[tblbl_attachments] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_attachments' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_attachments_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_attachments_ad' and type = 'tr') drop trigger[trbl_attachments_ad]; -- go create trigger [dbo].[trbl_attachments_ad] on [dbo].[tblbl_attachments] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_attachments' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_attachments_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_surbl_au' and type = 'tr') drop trigger[trbl_surbl_au]; -- go create trigger [dbo].[trbl_surbl_au] on [dbo].[tblbl_surbl] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_surbl' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_surbl_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_surbl_ai' and type = 'tr') drop trigger[trbl_surbl_ai]; -- go create trigger [dbo].[trbl_surbl_ai] on [dbo].[tblbl_surbl] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_surbl' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_surbl_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_surbl_ad' and type = 'tr') drop trigger[trbl_surbl_ad]; -- go create trigger [dbo].[trbl_surbl_ad] on [dbo].[tblbl_surbl] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_surbl' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_surbl_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_ips_au' and type = 'tr') drop trigger[trbl_ips_au]; -- go create trigger [dbo].[trbl_ips_au] on [dbo].[tblbl_ips] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_ips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_ips_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_ips_ai' and type = 'tr') drop trigger[trbl_ips_ai]; -- go create trigger [dbo].[trbl_ips_ai] on [dbo].[tblbl_ips] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_ips' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_ips_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_ips_ad' and type = 'tr') drop trigger[trbl_ips_ad]; -- go create trigger [dbo].[trbl_ips_ad] on [dbo].[tblbl_ips] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_ips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_ips_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_au' and type = 'tr') drop trigger[trbl_honeypotemails_au]; -- go create trigger [dbo].[trbl_honeypotemails_au] on [dbo].[tblbl_honeypotemails] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotemails' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotemails_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_ai' and type = 'tr') drop trigger[trbl_honeypotemails_ai]; -- go create trigger [dbo].[trbl_honeypotemails_ai] on [dbo].[tblbl_honeypotemails] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_honeypotemails' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotemails_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotemails_ad' and type = 'tr') drop trigger[trbl_honeypotemails_ad]; -- go create trigger [dbo].[trbl_honeypotemails_ad] on [dbo].[tblbl_honeypotemails] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotemails' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotemails_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_au' and type = 'tr') drop trigger[trbl_honeypotblockedips_au]; -- go create trigger [dbo].[trbl_honeypotblockedips_au] on [dbo].[tblbl_honeypotblockedips] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotblockedips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotblockedips_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_ai' and type = 'tr') drop trigger[trbl_honeypotblockedips_ai]; -- go create trigger [dbo].[trbl_honeypotblockedips_ai] on [dbo].[tblbl_honeypotblockedips] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tblbl_honeypotblockedips' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotblockedips_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'trbl_honeypotblockedips_ad' and type = 'tr') drop trigger[trbl_honeypotblockedips_ad]; -- go create trigger [dbo].[trbl_honeypotblockedips_ad] on [dbo].[tblbl_honeypotblockedips] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tblbl_honeypotblockedips' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'trbl_honeypotblockedips_ad' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_filtersettings_au' and type = 'tr') drop trigger[tr_filtersettings_au]; -- go create trigger [dbo].[tr_filtersettings_au] on [dbo].[tbl_filtersettings] after update as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tbl_filtersettings' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_filtersettings_au' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_filtersettings_ai' and type = 'tr') drop trigger[tr_filtersettings_ai]; -- go create trigger [dbo].[tr_filtersettings_ai] on [dbo].[tbl_filtersettings] for insert as insert into tblreloadtableinfo (domainid, updatetable, tablename) select ins.domainid, 1, 'tbl_filtersettings' from inserted ins where not exists (select * from tblreloadtableinfo r where (r.domainid = ins.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_filtersettings_ai' in the database ===========Executing:============
-- if exists (select * from sysobjects where name = 'tr_filtersettings_ad' and type = 'tr') drop trigger[tr_filtersettings_ad]; -- go create trigger [dbo].[tr_filtersettings_ad] on [dbo].[tbl_filtersettings] after delete as insert into tblreloadtableinfo (domainid, updatetable, tablename) select del.domainid, 1, 'tbl_filtersettings' from deleted del where not exists (select * from tblreloadtableinfo r where (r.domainid = del.domainid) and (r.tablename = tablename))
******* Error:There is already an object named 'tr_filtersettings_ad' in the database
There is already an object named 'tblbl_domains' in the database
Cannot insert duplicate key row in object 'dbo.tbl_localdomains' with unique index 'domainname'
There is already an object named 'tr_localdomains_au' in the database
There is already an object named 'tr_localdomains_ai' in the database
There is already an object named 'tr_localdomains_ad' in the database
There is already an object named 'tr_localdomains_bd' in the database
There is already an object named 'trwl_authorizedtoemails_au' in the database
There is already an object named 'trwl_authorizedtoemails_ai' in the database
There is already an object named 'trwl_authorizedtoemails_ad' in the database
There is already an object named 'trwl_keywords_au' in the database
There is already an object named 'trwl_keywords_ai' in the database
There is already an object named 'trwl_keywords_ad' in the database
There is already an object named 'trwl_emailsfrom_au' in the database
There is already an object named 'trwl_emailsfrom_ai' in the database
There is already an object named 'trwl_emailsfrom_ad' in the database
There is already an object named 'trwl_emailsto_au' in the database
There is already an object named 'trwl_emailsto_ai' in the database
There is already an object named 'trwl_emailsto_ad' in the database
There is already an object named 'trwl_domainsips_au' in the database
There is already an object named 'trwl_domainsips_ai' in the database
There is already an object named 'trwl_domainsips_ad' in the database
There is already an object named 'trwl_autowhitelistforcedelivery_au' in the database
There is already an object named 'trwl_autowhitelistforcedelivery_ai' in the database
There is already an object named 'trwl_autowhitelistforcedelivery_ad' in the database
There is already an object named 'trbl_domains_au' in the database
There is already an object named 'trbl_domains_ai' in the database
There is already an object named 'trbl_domains_ad' in the database
There is already an object named 'trbl_emailsfrom_au' in the database
There is already an object named 'trbl_emailsfrom_ai' in the database
There is already an object named 'trbl_emailsfrom_ad' in the database
There is already an object named 'trbl_emailsto_au' in the database
There is already an object named 'trbl_emailsto_ai' in the database
There is already an object named 'trbl_emailsto_ad' in the database
There is already an object named 'trbl_countries_au' in the database
There is already an object named 'trbl_countries_ai' in the database
There is already an object named 'trbl_countries_ad' in the database
There is already an object named 'trbl_maps_au' in the database
There is already an object named 'trbl_maps_ai' in the database
There is already an object named 'trbl_maps_ad' in the database
There is already an object named 'trbl_keywords_au' in the database
There is already an object named 'trbl_keywords_ai' in the database
There is already an object named 'trbl_keywords_ad' in the database
There is already an object named 'trbl_attachments_au' in the database
There is already an object named 'trbl_attachments_ai' in the database
There is already an object named 'trbl_attachments_ad' in the database
There is already an object named 'trbl_surbl_au' in the database
There is already an object named 'trbl_surbl_ai' in the database
There is already an object named 'trbl_surbl_ad' in the database
There is already an object named 'trbl_ips_au' in the database
There is already an object named 'trbl_ips_ai' in the database
There is already an object named 'trbl_ips_ad' in the database
There is already an object named 'trbl_honeypotemails_au' in the database
There is already an object named 'trbl_honeypotemails_ai' in the database
There is already an object named 'trbl_honeypotemails_ad' in the database
There is already an object named 'trbl_honeypotblockedips_au' in the database
There is already an object named 'trbl_honeypotblockedips_ai' in the database
There is already an object named 'trbl_honeypotblockedips_ad' in the database
There is already an object named 'tr_filtersettings_au' in the database
There is already an object named 'tr_filtersettings_ai' in the database
There is already an object named 'tr_filtersettings_ad' in the database Retrieved ServerID from tblServers: 1 Done.
|