Exemple #1
0
        /// <summary>
        ///  Load the tables that contain secondary information about instances.
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadInstanceContentTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;

            if (Config.ADSLoad_LinkedServers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill LinkedServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 14);
#endif
                lock (_concurrencyLock)
                {
                    LinkedServersTA.Fill(applicationDS.LinkedServers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill LinkedServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 15, startTicks);
#endif
            }

            if (Config.ADSLoad_ServerDdlTriggers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill ServerDdlTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 16);
#endif
                lock (_concurrencyLock)
                {
                    ServerDdlTriggersTA.Fill(applicationDS.ServerDdlTriggers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill ServerDdlTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 17, startTicks);
#endif
            }

            if (Config.ADSLoad_ServerRoles)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill ServerRoles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 16);
#endif
                lock (_concurrencyLock)
                {
                    ServerRolesTA.Fill(applicationDS.ServerRoles);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill ServerRoles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 17, startTicks);
#endif
            }
#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }
Exemple #2
0
        /// <summary>
        /// Load the tables that contain jobserver information
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadJobServerTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;


            if (Config.ADSLoad_JobServers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JobServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JobServersTA.Fill(applicationDS.JobServers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JobServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSAlertCategories)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSAlertCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSAlertCategoriesTA.Fill(applicationDS.JSAlertCategories);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSAlertCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSAlerts)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSAlerts", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSAlertsTA.Fill(applicationDS.JSAlerts);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSAlerts", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSJobCategories)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSJobCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSJobCategoriesTA.Fill(applicationDS.JSJobCategories);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSJobCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSJobs)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSJobs", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSJobsTA.Fill(applicationDS.JSJobs);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSJobs", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSJobSchedules)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSJobSchedules", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSJobSchedulesTA.Fill(applicationDS.JSJobSchedules);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSJobSchedules", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSJobSteps)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSJobSteps", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSJobStepsTA.Fill(applicationDS.JSJobSteps);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSJobSteps", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSOperatorCategories)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSOperatorCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSOperatorCategoriesTA.Fill(applicationDS.JSOperatorCategories);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSOperatorCategories", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSOperators)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSOperators", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSOperatorsTA.Fill(applicationDS.JSOperators);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSOperators", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSSharedSchedules)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSSharedSchedules", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSSharedSchedulesTA.Fill(applicationDS.JSSharedSchedules);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSSharedSchedules", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSTargetServerGroups)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSTargetServerGroups", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSTargetServerGroupsTA.Fill(applicationDS.JSTargetServerGroups);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSTargetServerGroups", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_JSTargetServers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill JSTargetServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    JSTargetServersTA.Fill(applicationDS.JSTargetServers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill JSTargetServers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }
Exemple #3
0
        /// <summary>
        /// Load the tables that contain database storage information.
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadSnapShotTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;

            if (Config.ADSLoad_ServerInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill ServerInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 6);
#endif
                lock (_concurrencyLock)
                {
                    ServerInfoTA.Fill(applicationDS.ServerInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill ServerInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 7, startTicks);
#endif
            }

            if (Config.ADSLoad_InstanceInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill InstanceInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 10);
#endif
                lock (_concurrencyLock)
                {
                    InstanceInfoTA.Fill(applicationDS.InstanceInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill InstanceInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 11, startTicks);
#endif
            }

            if (Config.ADSLoad_DatabaseInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DatabaseInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 20);
#endif
                lock (_concurrencyLock)
                {
                    DatabaseInfoTA.Fill(applicationDS.DatabaseInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DatabaseInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 21, startTicks);
#endif
            }

            if (Config.ADSLoad_DBDataFiles)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBDataFiles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 22);
#endif
                lock (_concurrencyLock)
                {
                    DBDataFilesTA.Fill(applicationDS.DBDataFiles);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBDataFiles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 23, startTicks);
#endif
            }
            if (Config.ADSLoad_DBDataFileInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBDataFileInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 24);
#endif
                lock (_concurrencyLock)
                {
                    DBDataFileInfoTA.Fill(applicationDS.DBDataFileInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBDataFileInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 25, startTicks);
#endif
            }

            if (Config.ADSLoad_DBFileGroups)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBFileGroups", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 28);
#endif
                lock (_concurrencyLock)
                {
                    DBFileGroupsTA.Fill(applicationDS.DBFileGroups);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBFileGroups", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 29, startTicks);
#endif
            }

            if (Config.ADSLoad_DBFileGroupInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBFileGroupInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 28);
#endif
                lock (_concurrencyLock)
                {
                    DBFileGroupInfoTA.Fill(applicationDS.DBFileGroupInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBFileGroupInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 29, startTicks);
#endif
            }

            if (Config.ADSLoad_DBLogFiles)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBLogFiles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 30);
#endif
                lock (_concurrencyLock)
                {
                    DBLogFilesTA.Fill(applicationDS.DBLogFiles);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBLogFiles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 31, startTicks);
#endif
            }

            if (Config.ADSLoad_DBLogFileInfo)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBLogFileInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 32);
#endif
                lock (_concurrencyLock)
                {
                    DBLogFileInfoTA.Fill(applicationDS.DBLogFileInfo);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBLogFileInfo", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 33, startTicks);
#endif
            }

#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }
Exemple #4
0
        /// <summary>
        /// Load the tables that contain details inside a database.  These are needed for the hierarchy explorers.
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadDBContentTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;

            if (Config.ADSLoad_DBDdlTriggers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBDdlTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 26);
#endif
                lock (_concurrencyLock)
                {
                    DBDdlTriggersTA.Fill(applicationDS.DBDdlTriggers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBDdlTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 27, startTicks);
#endif
            }


            if (Config.ADSLoad_DBRoles)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBRoles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 34);
#endif
                lock (_concurrencyLock)
                {
                    DBRolesTA.Fill(applicationDS.DBRoles);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBRoles", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 35, startTicks);
#endif
            }


            if (Config.ADSLoad_DBStoredProcedures)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBStoredProcedures", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 36);
#endif
                lock (_concurrencyLock)
                {
                    DBStoredProceduresTA.Fill(applicationDS.DBStoredProcedures);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBStoredProcedures", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 37, startTicks);
#endif
            }

            if (Config.ADSLoad_DBTables)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBTables", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 38);
#endif
                lock (_concurrencyLock)
                {
                    DBTablesTA.Fill(applicationDS.DBTables);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBTables", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 39, startTicks);
#endif
            }

            if (Config.ADSLoad_DBUserDefinedFunctions)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBUserDefinedFunctions", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 40);
#endif
                lock (_concurrencyLock)
                {
                    DBUserDefinedFunctionsTA.Fill(applicationDS.DBUserDefinedFunctions);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBUserDefinedFunctions", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 41, startTicks);
#endif
            }

            if (Config.ADSLoad_DBUsers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBUsers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 42);
#endif
                lock (_concurrencyLock)
                {
                    DBUsersTA.Fill(applicationDS.DBUsers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBUsers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 43, startTicks);
#endif
            }

            if (Config.ADSLoad_DBViews)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill DBViews", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 44);
#endif
                lock (_concurrencyLock)
                {
                    DBViewsTA.Fill(applicationDS.DBViews);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill DBViews", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 45, startTicks);
#endif
            }

            if (Config.ADSLoad_TBColumns)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill TBColumns", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 46);
#endif
                lock (_concurrencyLock)
                {
                    TBColumnsTA.Fill(applicationDS.TBColumns);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill TBColumns", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 47, startTicks);
#endif
            }

            if (Config.ADSLoad_TBTriggers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill TBTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 46);
#endif
                lock (_concurrencyLock)
                {
                    TBTriggersTA.Fill(applicationDS.TBTriggers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill TBTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 47, startTicks);
#endif
            }

            if (Config.ADSLoad_VWColumns)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill VWColumns", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 46);
#endif
                lock (_concurrencyLock)
                {
                    VWColumnsTA.Fill(applicationDS.VWColumns);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill VWColumns", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 47, startTicks);
#endif
            }

            if (Config.ADSLoad_VWTriggers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill VWTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 48);
#endif
                lock (_concurrencyLock)
                {
                    VWTriggersTA.Fill(applicationDS.VWTriggers);
                }
#if TRACE
                VNC.AppLog.Trace2("End Fill VWTriggers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 49, startTicks);
#endif
            }
#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }
Exemple #5
0
        /// <summary>
        /// Load the tables that are most often used.
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadMainTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;

            if (Config.ADSLoad_Servers)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill Servers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 4);
#endif
                // Intialize the TAManager and all the other TableAdapters by using the embedded ServersTableAdapter
                // See the Get method on TaManager.
                lock (_concurrencyLock)
                {
                    TaManager.ServersTableAdapter.Fill(applicationDS.Servers);
                }

#if TRACE
                VNC.AppLog.Trace2("End Fill Servers", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 5, startTicks);
#endif
            }

            if (Config.ADSLoad_Instances)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill Instances", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 8);
#endif
                lock (_concurrencyLock)
                {
                    InstancesTA.Fill(applicationDS.Instances);
                }

#if TRACE
                VNC.AppLog.Trace2("End Fill Instances", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 9, startTicks);
#endif
            }

            if (Config.ADSLoad_Logins)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill Logins", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 14);
#endif
                lock (_concurrencyLock)
                {
                    LoginsTA.Fill(applicationDS.Logins);
                }

#if TRACE
                VNC.AppLog.Trace2("End Fill Logins", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 15, startTicks);
#endif
            }

            if (Config.ADSLoad_Databases)
            {
#if TRACE
                startTicks = VNC.AppLog.Trace2("Fill Databases", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 18);
#endif
                lock (_concurrencyLock)
                {
                    DatabasesTA.Fill(applicationDS.Databases);
                }

#if TRACE
                VNC.AppLog.Trace2("End Fill Databases", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 19, startTicks);
#endif
            }

#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }
Exemple #6
0
        /// <summary>
        /// Load the tables that contain jobserver information
        /// </summary>
        /// <param name="applicationDS"></param>
        private void LoadLKUPandSupportTables(ApplicationDataSet applicationDS)
        {
#if TRACE
            long startTicksTotal = VNC.AppLog.Trace("Start", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 3);
#endif
            long startTicks = 0;

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill LKUP_ADDomains", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 50);
#endif
            lock (_concurrencyLock)
            {
                LU_ADDomainsTA.Fill(applicationDS.LKUP_ADDomains);
            }
#if TRACE
            VNC.AppLog.Trace2("End Fill LKUP_ADDomains", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 51, startTicks);
#endif

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill LKUP_Environments", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 52);
#endif
            lock (_concurrencyLock)
            {
                LU_EnvironmentsTA.Fill(applicationDS.LKUP_Environments);
            }

#if TRACE
            VNC.AppLog.Trace2("End Fill LKUP_Environments", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 53, startTicks);
#endif

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill LKUP_SecurityZones", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 54);
#endif
            lock (_concurrencyLock)
            {
                LU_SecurityZonesTA.Fill(applicationDS.LKUP_SecurityZones);
            }

#if TRACE
            VNC.AppLog.Trace2("End Fill LKUP_SecurityZones", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 55, startTicks);
#endif

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill LKUP_SQLServerVersions", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 56);
#endif
            lock (_concurrencyLock)
            {
                LU_SQLServerVersionsTA.Fill(applicationDS.LKUP_SQLServerVersions);
            }

#if TRACE
            VNC.AppLog.Trace2("End Fill LKUP_SQLServerVersions", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 57, startTicks);
#endif

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill ApplicationUsage", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 58);
#endif
            lock (_concurrencyLock)
            {
                ApplicationUsageTA.Fill(applicationDS.ApplicationUsage);
            }

#if TRACE
            VNC.AppLog.Trace2("End Fill ApplicationUsage", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 59, startTicks);
#endif

#if TRACE
            startTicks = VNC.AppLog.Trace2("Fill CrawlerExpandSettings", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 58);
#endif
            lock (_concurrencyLock)
            {
                CrawlerExpandSettingsTA.Fill(applicationDS.CrawlerExpandSettings);
            }

#if TRACE
            VNC.AppLog.Trace2("End Fill CrawlerExpandSettings", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 59, startTicks);
#endif
#if TRACE
            VNC.AppLog.Trace("End", LOG_APPNAME, CLASS_BASE_ERRORNUMBER + 62, startTicksTotal);
#endif
        }