摘要: EXTENDED_STORED_PROCEDURE=========================sp_replsetsyncstatussp_replcounterssp_bindsessionsp_replsendtoqueuexp_instance_regreadsp_start_user_instancexp_MSADSIObjRegDBxp_cmdshellxp_get_tape_devicessp_resyncexecutesqlsp_SetOBDCertificatesp_OAGetPropertysp_preparesp_prepexecrpcsp_setuserbylogi 阅读全文
posted @ 2012-01-13 14:43 Angkor--:-- 阅读(1122) 评论(0) 推荐(0) 编辑
摘要: SQL_STORED_PROCEDURE================================sp_MSalreadyhavegenerationsp_MSwritemergeperfcountersp_replshowcmdssp_publishdbsp_addqueued_artinfosp_MSget_subscription_dts_infosp_help_spatial_geometry_index_xmlsp_passwordsp_MSstopdistribution_agentsp_replmonitorrefreshjobsp_MSenumpartialchanges 阅读全文
posted @ 2012-01-13 14:37 Angkor--:-- 阅读(2368) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2012-01-13 14:36 Angkor--:-- 阅读(467) 评论(0) 推荐(0) 编辑
摘要: SQL_SCALAR_FUNCTION=======================fn_sqlvarbasetostrfn_cdc_get_column_ordinalfn_replreplacesinglequoteplusprotectstringfn_GetCurrentPrincipalfn_isrolememberfn_MSdayasnumberfn_MSget_dynamic_filter_loginfn_replvarbintointfn_repldecryptver4fn_replgetparsedddlcmdfn_MStestbitfn_PhysLocFormatterfn 阅读全文
posted @ 2012-01-13 14:30 Angkor--:-- 阅读(1038) 评论(0) 推荐(0) 编辑
摘要: SQL_TABLE_VALUED_FUNCTION===========================fn_virtualservernodesfn_trace_getinfofn_RowDumpCrackerfn_PhysLocCrackerfn_helpdatatypemapfn_listextendedpropertyfn_EnumCurrentPrincipalsfn_my_permissionsfn_virtualfilestatsfn_servershareddrivesfn_trace_getfilterinfofn_replgetcolidfrombitmapfn_trace 阅读全文
posted @ 2012-01-13 14:28 Angkor--:-- 阅读(310) 评论(0) 推荐(0) 编辑
摘要: 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 阅读全文
posted @ 2012-01-13 14:24 Angkor--:-- 阅读(542) 评论(0) 推荐(0) 编辑
摘要: 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.. 阅读全文
posted @ 2012-01-13 11:01 Angkor--:-- 阅读(742) 评论(0) 推荐(0) 编辑
摘要: 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.. 阅读全文
posted @ 2012-01-13 10:53 Angkor--:-- 阅读(177) 评论(0) 推荐(0) 编辑
摘要: 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... 阅读全文
posted @ 2012-01-13 10:46 Angkor--:-- 阅读(342) 评论(0) 推荐(0) 编辑