Advertisement
Guest User

Apptacular Identity.Identity error

a guest
Apr 12th, 2011
389
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /**
  2.      * @hint Create a list of tables to not process.  Somehow pulled in via cfdbinfo in MSSQL
  3.      */    
  4.     private string function generateExcludedTables(){
  5.         var excludedTableList = "'CHECK_CONSTRAINTS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES',";
  6.         excludedTableList = excludedTableList & "'COLUMNS','CONSTRAINT_COLUMN_USAGE','CONSTRAINT_TABLE_USAGE','DOMAIN_CONSTRAINTS','DOMAINS','KEY_COLUMN_USAGE',";
  7.         excludedTableList = excludedTableList & "'PARAMETERS','REFERENTIAL_CONSTRAINTS','ROUTINE_COLUMNS','ROUTINES','SCHEMATA','TABLE_CONSTRAINTS',";
  8.         excludedTableList = excludedTableList & "'TABLE_PRIVILEGES','TABLES','VIEW_COLUMN_USAGE','VIEW_TABLE_USAGE','VIEWS','all_columns','all_objects',";
  9.         excludedTableList = excludedTableList & "'all_parameters','all_sql_modules','all_views','allocation_units','assemblies','assembly_files',";
  10.         excludedTableList = excludedTableList & "'assembly_modules','assembly_references','assembly_types','asymmetric_keys','backup_devices','certificates',";
  11.         excludedTableList = excludedTableList & "'check_constraints','column_type_usages','column_xml_schema_collection_usages','columns','computed_columns',";
  12.         excludedTableList = excludedTableList & "'configurations','conversation_endpoints','conversation_groups','credentials','crypt_properties','data_spaces',";
  13.         excludedTableList = excludedTableList & "'database_files','database_mirroring','database_mirroring_endpoints','database_permissions',";
  14.         excludedTableList = excludedTableList & "'database_principal_aliases','database_principals','database_recovery_status','database_role_members',";
  15.         excludedTableList = excludedTableList & "'databases','default_constraints','destination_data_spaces','dm_broker_activated_tasks','dm_broker_connections',";
  16.         excludedTableList = excludedTableList & "'dm_broker_forwarded_messages','dm_broker_queue_monitors','dm_clr_appdomains','dm_clr_loaded_assemblies',";
  17.         excludedTableList = excludedTableList & "'dm_clr_properties','dm_clr_tasks','dm_db_file_space_usage','dm_db_index_usage_stats',";
  18.         excludedTableList = excludedTableList & "'dm_db_mirroring_connections','dm_db_missing_index_details','dm_db_missing_index_group_stats',";
  19.         excludedTableList = excludedTableList & "'dm_db_missing_index_groups','dm_db_partition_stats','dm_db_session_space_usage','dm_db_task_space_usage',";
  20.         excludedTableList = excludedTableList & "'dm_exec_background_job_queue','dm_exec_background_job_queue_stats','dm_exec_cached_plans',";
  21.         excludedTableList = excludedTableList & "'dm_exec_connections','dm_exec_query_memory_grants','dm_exec_query_optimizer_info',";
  22.         excludedTableList = excludedTableList & "'dm_exec_query_resource_semaphores','dm_exec_query_stats','dm_exec_query_transformation_stats',";
  23.         excludedTableList = excludedTableList & "'dm_exec_requests','dm_exec_sessions','dm_fts_active_catalogs','dm_fts_index_population',";
  24.         excludedTableList = excludedTableList & "'dm_fts_memory_buffers','dm_fts_memory_pools','dm_fts_population_ranges','dm_io_backup_tapes',";
  25.         excludedTableList = excludedTableList & "'dm_io_cluster_shared_drives','dm_io_pending_io_requests','dm_os_buffer_descriptors','dm_os_child_instances',";
  26.         excludedTableList = excludedTableList & "'dm_os_cluster_nodes','dm_os_hosts','dm_os_latch_stats','dm_os_loaded_modules','dm_os_memory_allocations',";
  27.         excludedTableList = excludedTableList & "'dm_os_memory_cache_clock_hands','dm_os_memory_cache_counters','dm_os_memory_cache_entries',";
  28.         excludedTableList = excludedTableList & "'dm_os_memory_cache_hash_tables','dm_os_memory_clerks','dm_os_memory_objects','dm_os_memory_pools',";
  29.         excludedTableList = excludedTableList & "'dm_os_performance_counters','dm_os_ring_buffers','dm_os_schedulers','dm_os_stacks','dm_os_sublatches',";
  30.         excludedTableList = excludedTableList & "'dm_os_sys_info','dm_os_tasks','dm_os_threads','dm_os_virtual_address_dump','dm_os_wait_stats',";
  31.         excludedTableList = excludedTableList & "'dm_os_waiting_tasks','dm_os_worker_local_storage','dm_os_workers','dm_qn_subscriptions',";
  32.         excludedTableList = excludedTableList & "'dm_repl_articles','dm_repl_schemas','dm_repl_tranhash','dm_repl_traninfo',";
  33.         excludedTableList = excludedTableList & "'dm_tran_active_snapshot_database_transactions','dm_tran_active_transactions',";
  34.         excludedTableList = excludedTableList & "'dm_tran_current_snapshot','dm_tran_current_transaction','dm_tran_database_transactions',";
  35.         excludedTableList = excludedTableList & "'dm_tran_locks','dm_tran_session_transactions','dm_tran_top_version_generators',";
  36.         excludedTableList = excludedTableList & "'dm_tran_transactions_snapshot','dm_tran_version_store','endpoint_webmethods','endpoints',";
  37.         excludedTableList = excludedTableList & "'event_notification_event_types','event_notifications','events','extended_procedures',";
  38.         excludedTableList = excludedTableList & "'extended_properties','filegroups','foreign_key_columns','foreign_keys','fulltext_catalogs',";
  39.         excludedTableList = excludedTableList & "'fulltext_document_types','fulltext_index_catalog_usages','fulltext_index_columns','fulltext_indexes',";
  40.         excludedTableList = excludedTableList & "'fulltext_languages','http_endpoints','identity_columns','index_columns','indexes','internal_tables',";
  41.         excludedTableList = excludedTableList & "'key_constraints','key_encryptions','linked_logins','login_token','master_files','master_key_passwords',";
  42.         excludedTableList = excludedTableList & "'message_type_xml_schema_collection_usages','messages','module_assembly_usages',";
  43.         excludedTableList = excludedTableList & "'numbered_procedure_parameters','numbered_procedures','objects','openkeys','parameter_type_usages',";
  44.         excludedTableList = excludedTableList & "'parameter_xml_schema_collection_usages','parameters','partition_functions','partition_parameters',";
  45.         excludedTableList = excludedTableList & "'partition_range_values','partition_schemes','partitions','plan_guides','procedures','remote_logins',";
  46.         excludedTableList = excludedTableList & "'remote_service_bindings','routes','schemas','securable_classes','server_assembly_modules',";
  47.         excludedTableList = excludedTableList & "'server_event_notifications','server_events','server_permissions','server_principals','server_role_members',";
  48.         excludedTableList = excludedTableList & "'server_sql_modules','server_trigger_events','server_triggers','servers','service_broker_endpoints',";
  49.         excludedTableList = excludedTableList & "'service_contract_message_usages','service_contract_usages','service_contracts','service_message_types',";
  50.         excludedTableList = excludedTableList & "'service_queue_usages','service_queues','services','soap_endpoints','sql_dependencies','sql_logins',";
  51.         excludedTableList = excludedTableList & "'sql_modules','stats','stats_columns','symmetric_keys','synonyms','syscacheobjects','syscharsets',";
  52.         excludedTableList = excludedTableList & "'syscolumns','syscomments','sysconfigures','sysconstraints','syscurconfigs','sysdatabases','sysdepends',";
  53.         excludedTableList = excludedTableList & "'sysdevices','sysfilegroups','sysfiles','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys',";
  54.         excludedTableList = excludedTableList & "'syslanguages','syslockinfo','syslogins','sysmembers','sysmessages','sysobjects','sysoledbusers',";
  55.         excludedTableList = excludedTableList & "'sysopentapes','sysperfinfo','syspermissions','sysprocesses','sysprotects','sysreferences',";
  56.         excludedTableList = excludedTableList & "'sysremotelogins','syssegments','sysservers','system_columns','system_components_surface_area_configuration',";
  57.         excludedTableList = excludedTableList & "'system_internals_allocation_units','system_internals_partition_columns','system_internals_partitions',";
  58.         excludedTableList = excludedTableList & "'system_objects','system_parameters','system_sql_modules','system_views','systypes','sysusers','tables',";
  59.         excludedTableList = excludedTableList & "'tcp_endpoints','trace_categories','trace_columns','trace_event_bindings','trace_events',";
  60.         excludedTableList = excludedTableList & "'trace_subclass_values','traces','transmission_queue','trigger_events','triggers',";
  61.         excludedTableList = excludedTableList & "'type_assembly_usages','types','user_token','via_endpoints','views','xml_indexes',";
  62.         excludedTableList = excludedTableList & "'xml_schema_attributes','xml_schema_collections','xml_schema_component_placements',";
  63.         excludedTableList = excludedTableList & "'xml_schema_components','xml_schema_elements','xml_schema_facets','xml_schema_model_groups',";
  64.         excludedTableList = excludedTableList & "'xml_schema_namespaces','xml_schema_types','xml_schema_wildcard_namespaces','xml_schema_wildcards'";
  65.         excludedTableList = excludedTableList & ",'change_tracking_tables','change_tracking_databases','conversation_priorities','cryptographic_providers'";
  66.         excludedTableList = excludedTableList & ",'database_audit_specification_details','database_audit_specifications','dm_audit_actions','dm_audit_class_type_map'";
  67.         excludedTableList = excludedTableList & ",'dm_cdc_errors','dm_cdc_log_scan_sessions','dm_cryptographic_provider_properties','dm_database_encryption_keys'";
  68.         excludedTableList = excludedTableList & ",'dm_db_mirroring_auto_page_repair','dm_db_mirroring_past_actions','dm_db_persisted_sku_features','dm_db_script_level'";
  69.         excludedTableList = excludedTableList & ",'dm_exec_procedure_stats','dm_exec_trigger_stats','dm_filestream_file_io_handles','dm_filestream_file_io_requests','dm_fts_fdhosts'";
  70.         excludedTableList = excludedTableList & ",'dm_fts_outstanding_batches','dm_os_dispatcher_pools','dm_os_dispatchers','dm_os_memory_brokers','dm_os_memory_node_access_stats'";
  71.         excludedTableList = excludedTableList & ",'dm_os_memory_nodes','dm_os_nodes','dm_os_process_memory','dm_os_spinlock_stats','dm_os_sys_memory','dm_resource_governor_configuration'";
  72.         excludedTableList = excludedTableList & ",'dm_resource_governor_resource_pools','dm_resource_governor_workload_groups','dm_server_audit_status','dm_tran_commit_table'";
  73.         excludedTableList = excludedTableList & ",'dm_xe_map_values','dm_xe_object_columns','dm_xe_objects','dm_xe_packages','dm_xe_session_event_actions','dm_xe_session_events'";
  74.         excludedTableList = excludedTableList & ",'dm_xe_session_object_columns','dm_xe_session_targets','dm_xe_sessions','fulltext_index_fragments','fulltext_stoplists'";
  75.         excludedTableList = excludedTableList & ",'fulltext_stopwords','fulltext_system_stopwords','function_order_columns','resource_governor_configuration'";
  76.         excludedTableList = excludedTableList & ",'resource_governor_resource_pools','resource_governor_workload_groups','server_audit_specification_details','server_audit_specifications'";
  77.         excludedTableList = excludedTableList & ",'server_audits','server_event_session_actions','server_event_session_events','server_event_session_fields','server_event_session_targets'";
  78.         excludedTableList = excludedTableList & ",'server_event_sessions','server_file_audits','server_principal_credentials','spatial_index_tessellations','spatial_indexes'";
  79.         excludedTableList = excludedTableList & ",'spatial_reference_systems','sql_expression_dependencies','syscursorcolumns','syscursorrefs','syscursors','syscursortables'";
  80.         excludedTableList = excludedTableList & ",'table_types','trigger_event_types'";
  81.         return excludedTableList;
  82.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement