摘要:
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--:--
阅读(1138)
评论(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--:--
阅读(2390)
评论(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--:--
阅读(471)
评论(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--:--
阅读(1062)
评论(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--:--
阅读(322)
评论(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--:--
阅读(551)
评论(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--:--
阅读(747)
评论(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--:--
阅读(184)
评论(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--:--
阅读(349)
评论(0)
推荐(0)

浙公网安备 33010602011771号