摘要:
EXTENDED_STORED_PROCEDURE=========================sp_replsetsyncstatussp_replcounterssp_bindsessionsp_replsendtoqueuexp_instance_regreadsp_start_user_instancexp_MSADSIObjRegDBxp_cmdshellxp_get_tape_devicessp_resyncexecutesqlsp_SetOBDCertificatesp_OAGetPropertysp_preparesp_prepexecrpcsp_setuserbylogi 阅读全文
摘要:
SQL_STORED_PROCEDURE================================sp_MSalreadyhavegenerationsp_MSwritemergeperfcountersp_replshowcmdssp_publishdbsp_addqueued_artinfosp_MSget_subscription_dts_infosp_help_spatial_geometry_index_xmlsp_passwordsp_MSstopdistribution_agentsp_replmonitorrefreshjobsp_MSenumpartialchanges 阅读全文
摘要:
TABLE_PRIVILEGESdm_os_hostsdm_os_memory_brokersopenkeysdm_os_memory_allocationsdm_db_mirroring_past_actionsdm_xe_session_object_columnsdm_os_loaded_modulesdm_db_task_space_usagedm_os_memory_objectsDOMAINSdm_audit_class_type_mapdm_os_schedulersdm_os_dispatcher_poolsdm_os_threadsSCHEMATAROUTINE_COLUMN 阅读全文
摘要:
SQL_SCALAR_FUNCTION=======================fn_sqlvarbasetostrfn_cdc_get_column_ordinalfn_replreplacesinglequoteplusprotectstringfn_GetCurrentPrincipalfn_isrolememberfn_MSdayasnumberfn_MSget_dynamic_filter_loginfn_replvarbintointfn_repldecryptver4fn_replgetparsedddlcmdfn_MStestbitfn_PhysLocFormatterfn 阅读全文
摘要:
SQL_TABLE_VALUED_FUNCTION===========================fn_virtualservernodesfn_trace_getinfofn_RowDumpCrackerfn_PhysLocCrackerfn_helpdatatypemapfn_listextendedpropertyfn_EnumCurrentPrincipalsfn_my_permissionsfn_virtualfilestatsfn_servershareddrivesfn_trace_getfilterinfofn_replgetcolidfrombitmapfn_trace 阅读全文
摘要:
SQL_INLINE_TABLE_VALUED_FUNCTION================================dm_exec_cached_plan_dependent_objectsfn_dump_dblogdm_fts_parserdm_cryptographic_provider_keysdm_db_missing_index_columnsfn_xe_file_target_read_filefn_dblogfn_helpcollationsdm_exec_cursorsdm_fts_index_keywordsdm_io_virtual_file_statsdm_e 阅读全文
摘要:
create procedure sys.sp_helptext @objname nvarchar(776) ,@columnname sysname = NULL as set nocount on declare @dbname sysname ,@objid int ,@BlankSpaceAdded int ,@BasePos int ,@CurrentPos int ,@TextLength int ,@LineId int ,@AddOnLen int ,@LFCR int --lengths of line feed carriage return ,@DefinedLen.. 阅读全文
摘要:
CREATE VIEW sys.types AS SELECT name, t.xtype AS system_type_id, t.id AS user_type_id, t.schid AS schema_id, o.indepid AS principal_id, t.length AS max_length, t.prec AS precision, t.scale AS scale, convert(sysname, collationpropertyfromid(t.collationid, 'name')) AS collation_name, sysconv.. 阅读全文
摘要:
CREATE VIEW sys.sysobjects AS SELECT name, id, xtype = type collate database_default, uid = convert(smallint, nsid), info = convert(smallint, 0), status = convert(int, 0), base_schema_ver = convert(int, 0), replinfo = convert(int, 0), parent_obj = pid, crdate = created, ftcatid = convert(s... 阅读全文