Showing posts with label My Library of SQL Server procedures and functions. Show all posts
Showing posts with label My Library of SQL Server procedures and functions. Show all posts

Thursday, March 29, 2012

My SQL Server DBATools library function and procedure index.

As a DBA working with SQL Server for the last 20 years  I have collected quite a few functions  and procedures. Most the code for this library has been assimilated from the internet and a many of the procedures have been modified to be server independent so they can be run targeting specific servers That being a very time consuming  process not all the code has been converted completely to my liking. That being said there is a ton of functionality built into this DB Tools library. Please find a list of  functions  and procedures below or view them directly by clicking on functions  or procedures.  


  1. FUNCTION.bigint.udf_ConvertBinaryStringToBigInt
  2. FUNCTION.bigint.udf_IsNullNum
  3. FUNCTION.bigint.udf_str_CountStrings
  4. FUNCTION.bit.fnIsColumnPrimaryKey
  5. FUNCTION.bit.fnTableHasPrimaryKey
  6. FUNCTION.bit.udf_config_clr_enabled
  7. FUNCTION.bit.udf_config_use_trusted
  8. FUNCTION.bit.udf_fs_CheckFileStatus
  9. FUNCTION.bit.udf_fs_FileExist
  10. FUNCTION.bit.udf_IsInList
  11. FUNCTION.bit.udf_IsInRange
  12. FUNCTION.bit.udf_IsInRegion
  13. FUNCTION.bit.udf_IsNumHoursFromMidnght
  14. FUNCTION.bit.udf_IsPath
  15. FUNCTION.bit.udf_IsQuoted
  16. FUNCTION.bit.udf_IsSelect
  17. FUNCTION.bit.udf_ProcessRecord
  18. FUNCTION.bit.udf_str_find_regular_expression
  19. FUNCTION.bit.udf_str_IsNumeric
  20. FUNCTION.bit.udf_wc_is_all_value
  21. FUNCTION.bit.UTIL_IsInAsciiRange
  22. FUNCTION.bit.UTIL_IsUpperCase
  23. FUNCTION.char.CustomerNumber
  24. FUNCTION.char.udf_bitmap
  25. FUNCTION.char.udf_bitmap_right
  26. FUNCTION.char. udf_DateToFirstDateOfMonthKey
  27. FUNCTION.datetime.fn_AgentDate2DateTime
  28. FUNCTION.datetime.fn_AgentDateTime2DateTime
  29. FUNCTION.datetime.fn_AgentTime2DateTime
  30. FUNCTION.datetime.fn_ToDate
  31. FUNCTION.datetime.udf__AgentDate2DateTime
  32. FUNCTION.datetime.udf_date_chanukah
  33. FUNCTION.datetime.udf_date_DayFifteen
  34. FUNCTION.datetime.udf_date_easter
  35. FUNCTION.datetime.udf_date_OEaster
  36. FUNCTION.datetime.udf_date_Passover
  37. FUNCTION.datetime.udf_date_TishaBAv
  38. FUNCTION.datetime.udf_date_TuBishvat
  39. FUNCTION.datetime.udf_date_YomHaAtzmaut
  40. FUNCTION.datetime.udf_DateMin
  41. FUNCTION.datetime.udf_DatePartLastValue
  42. FUNCTION.datetime.udf_dt_add
  43. FUNCTION.datetime.udf_DT_AddTime
  44. FUNCTION.datetime.udf_dt_first
  45. FUNCTION.datetime.udf_dt_last
  46. FUNCTION.datetime.udf_dt_minute_round
  47. FUNCTION.datetime.udf_dt_period_add
  48. FUNCTION.datetime.udf_FirstDateOfDatePart
  49. FUNCTION.datetime.udf_FirstDayOfMonth
  50. FUNCTION.datetime.udf_FirstDayOf Week
  51. FUNCTION.datetime.udf_FirstDayQuarter
  52. FUNCTION.datetime.udf_FirstDayYear
  53. FUNCTION.datetime.udf_FirstSecondOfDay
  54. FUNCTION.datetime.udf_FormatDateRoundByMinute
  55. FUNCTION.datetime.udf_FormatDateString
  56. FUNCTION.datetime.udf_GetLastLogShipDateTime
  57. FUNCTION.datetime.udf_GetReportingDay
  58. FUNCTION.datetime.udf_LastDateOfDatePart
  59. FUNCTION.datetime.udf_LastDayOfMonth
  60. FUNCTION.datetime.udf_LastDayOfQuarter
  61. FUNCTION.datetime.udf_LastDayOfWeek
  62. FUNCTION.datetime.udf_LastDayOfYear
  63. FUNCTION.datetime.udf_LastSecondOfDay
  64. FUNCTION.datetime.udf_MonthKeyToDate
  65. FUNCTION.datetime.udf_srvr_InstanceStartTime
  66. FUNCTION.datetime.udf_str_FormatRunDate
  67. FUNCTION.datetime.udf_str_FormatRunTime
  68. FUNCTION.decimal.udf_Age
  69. FUNCTION.decimal.udf_calc_growth
  70. FUNCTION.decimal.udf_dec_DateToMonthKey
  71. FUNCTION.decimal.udf_dec_percentage
  72. FUNCTION.decimal.udf_fn_pmt
  73. FUNCTION.decimal.udf_fs_FileSizeInMB
  74. FUNCTION.decimal.udf_P mt
  75. FUNCTION.decimal.udf_str_FormatRunDuration
  76. FUNCTION.decimal.udf_str_size_convert
  77. FUNCTION.decimal.udf_str_size_to_mb
  78. FUNCTION.decimal.udf_str_to_number
  79. FUNCTION.int.DirExists
  80. FUNCTION.int.fn_DateTime2AgentDate
  81. FUNCTION.int.fn_DateTime2AgentTime
  82. FUNCTION.int.fn_diagramobjects
  83. FUNCTION.int.udf_bit_ZeroToNull
  84. FUNCTION.int.udf_column_datatype_priority
  85. FUNCTION.int.udf_CompleteWeekRange
  86. FUNCTION.int.udf_DateToIntYYYYMM
  87. FUNCTION.int.udf_DateToIntYYYYMMDD
  88. FUNCTION.int.udf_DateToMonthKey
  89. FUNCTION.int.udf_DateToWeekKey
  90. FUNCTION.int.udf_default_int_null
  91. FUNCTION.int.udf_dt_period
  92. FUNCTION.int.udf_int_DateToMonthKey
  93. FUNCTION.int.udf_int_Max
  94. FUNCTION.int.udf_int_Min
  95. FUNCTION.int.udf_int_SizeRec
  96. FUNCTION.int.udf_int_ZeroToNull
  97. FUNCTION.int.udf_IntToBinaryInt
  98. FUNCTION.int.udf_log_FileCopyMaxID
  99. FUNCTION.int.udf_MonthKeyDateAdd
  100. FUNCTION.int.udf_MonthKeyMin
  101. FUNCTION.int.udf_NthCharIndex
  102. FUNCTION.int.udf_OrdinalPosition
  103. FUNCTION.int.udf_RangeID
  104. FUNCTION.int.udf_Registry_WriteValue
  105. FUNCTION.int.udf_str_count_chars2
  106. FUNCTION.int.udf_str_CountChars
  107. FUNCTION.int.udf_str_cs_CountChar
  108. FUNCTION.int.udf_str_num_items
  109. FUNCTION.int.udf_str_ReplacePattern2_wip
  110. FUNCTION.int.udf_str_ReverseCharIndex
  111. FUNCTION.int.udf_UpperCharIndex
  112. FUNCTION.int.usp_date_WorkDays
  113. FUNCTION.money.udf_FV
  114. FUNCTION.money.udf_PV
  115. FUNCTION.numeric.udf_strIsNumeric
  116. FUNCTION.numeric.udf_strIsNumericNoSymbols
  117. FUNCTION.nvarchar.CHARINDEX_BIN
  118. FUNCTION.nvarchar.CHRTRAN
  119. FUNCTION.nvarchar.STRFILTER
  120. FUNCTION.nvarchar.udf_fmt_job_schedule
  121. FUNCTION.nvarchar.udf_srvr_config_SQLServerBackupDir
  122. FUNCTION.nvarchar.udf_srvr_config_SQLServerDataDir
  123. FUNCTION.nvarchar.udf_srvr_config_SQLServerDirTemp
  124. FUNCTION.nvarchar.udf_srvr_config_SQLServerInstallDir
  125. FUNCTION.nvarchar.udf_srvr_config_SQLServerLogDir
  126. FUNCTION.nvarcha r.u df_str_name_database
  127. FUNCTION.nvarchar.udf_str_name_schema
  128. FUNCTION.nvarchar.udf_str_name_server
  129. FUNCTION.nvarchar.udf_str_name_table
  130. FUNCTION.sql_variant.udf_Max
  131. FUNCTION.sql_variant.udf_Min
  132. FUNCTION.sql_variant.udf_ZeroToNull
  133. FUNCTION.TABLE.DirFiles
  134. FUNCTION.TABLE.DirFileSearch
  135. FUNCTION.TABLE.DirSubDirs
  136. FUNCTION.TABLE.FixedDrives
  137. FUNCTION.TABLE.fnTableColumnInfo
  138. FUNCTION.TABLE.udf_ParseString
  139. FUNCTION.TABLE.udf_ParseText2Table
  140. FUNCTION.TABLE.udf_str_Split
  141. FUNCTION.TABLE.udt_CommaSeparatedListToSingleColumn
  142. FUNCTION.TABLE.udt_database_tables
  143. FUNCTION.TABLE.udt_date_GetHolidayDates
  144. FUNCTION.TABLE.udt_DateRange
  145. FUNCTION.TABLE.udt_DateRanges
  146. FUNCTION.TABLE.udt_db_backups_missing
  147. FUNCTION.TABLE.udt_db_GetTriggerStatus
  148. FUNCTION.TABLE.udt_db_trig_status
  149. FUNCTION.TABLE.udt_db_trig_status_get
  150. FUNCTION.TABLE.udt_dba_dependancies_get
  151. FUNCTION.TABLE.udt_dba_FindDependencies
  152. FUNCTION.TAB LE.udt_dt_backup_intervals
  153. FUNCTION.TABLE.udt_dt_GetDateRange
  154. FUNCTION.TABLE.udt_dt_InitUserInputMonthly
  155. FUNCTION.TABLE.udt_fs_dir_clr
  156. FUNCTION.TABLE.udt_fs_dir_ext
  157. FUNCTION.TABLE.udt_fs_DirFiles
  158. FUNCTION.TABLE.udt_fs_file_read
  159. FUNCTION.TABLE.udt_fs_file_read_xml_value
  160. FUNCTION.TABLE.udt_fs_listfiles
  161. FUNCTION.TABLE.udt_fs_ReadFileAsTable
  162. FUNCTION.TABLE.udt_fs_sysname
  163. FUNCTION.TABLE.udt_GenerateDateIntervals
  164. FUNCTION.TABLE.udt_GenerateDates
  165. FUNCTION.TABLE.udt_GenerateMonthKeys
  166. FUNCTION.TABLE.udt_GeneratePeriodQuarters
  167. FUNCTION.TABLE.udt_GeneratePeriods
  168. FUNCTION.TABLE.udt_GenerateQuarterEndKeys
  169. FUNCTION.TABLE.udt_GenerateQuarterKeys
  170. FUNCTION.TABLE.udt_GenerateTimes
  171. FUNCTION.TABLE.udt_GenerateYears
  172. FUNCTION.TABLE.udt_index_recommendation_database_cross_ref
  173. FUNCTION.TABLE.udt_lu_backupset_type
  174. FUNCTION.TABLE.udt_lu_job_status
  175. FUNCTION.TABLE.udt_r_lu_DatePart
  176. FUNCTION.TABLE.udt_range_big int
  177. FUNCTION.TABLE.udt_schema_getColumnInfo
  178. FUNCTION.TABLE.udt_srvr_configuration_registry_info
  179. FUNCTION.TABLE.udt_sys_constraints
  180. FUNCTION.TABLE.udt_sys_foreign_keys_status
  181. FUNCTION.TABLE.udt_sys_PrimaryKeys
  182. FUNCTION.TABLE.udt_TempTableColumnNames
  183. FUNCTION.TABLE.udt_util_CommaSeparatedListToSingleColumn
  184. FUNCTION.TABLE.udt_util_foreign_keys_generate_commands
  185. FUNCTION.TABLE.usp_xml_ToTableVar
  186. FUNCTION.varchar.fn_FormatTelephoneNumber
  187. FUNCTION.varchar.fn_strIsNull
  188. FUNCTION.varchar.fn_Trim
  189. FUNCTION.varchar.fnCleanDefaultValue
  190. FUNCTION.varchar.fnColumnDefault
  191. FUNCTION.varchar.fnTablePrimaryKey
  192. FUNCTION.varchar.funProcWithoutComments
  193. FUNCTION.varchar.getColID
  194. FUNCTION.varchar.get ColList
  195. FUNCTION.varchar.PROPERCASE
  196. FUNCTION.varchar.StripAphaChars
  197. FUNCTION.varchar.StripNonAlphaChars
  198. FUNCTION.varchar.u2
  199. FUNCTION.varchar.udf_AddQuoteChars
  200. FUNCTION.varchar.udf_AddQuotesIfNotFound
  201. FUNCTION.varchar.udf_AddStrBeforeUpperChars
  202. FUNCTION.varchar.udf_AppendIfNotFound
  203. FUNCTION.varchar.udf_BinaryOrdinalPosition
  204. FUNCTION.varchar.udf_Coalesce
  205. FUNCTION.varchar.udf_Coalesce_Adv
  206. FUNCTION.varchar.udf_coalesced
  207. FUNCTION.varchar.udf_conv_VarbinaryToVarcharHex
  208. FUNCTION.varchar.udf_csv_compare
  209. FUNCTION.varchar.udf_DateGroupingDescription
  210. FUNCTION.varchar.udf_DatePart
  211. FUNCTION.varchar.udf_DatePartDesc
  212. FUNCTION.varchar.udf_DatePartFormat
  213. FUNCTION.varchar.udf_DatePartStd
  214. FUNCTION.varchar.udf_db_table_primary_key_columns
  215. FUNCTION.varchar.udf_db_table_primary_key_name
  216. FUNCTION.varchar.udf_default_str_null
  217. FUNCTION.varchar.udf_DefaultValue
  218. FUNCTION.varchar.udf_FindWildcardPattern
  219. FUN CTION.varchar.udf_FormatName
  220. FUNCTION.varchar.udf_FormatYearString
  221. FUNCTION.varchar.udf_fs_file_read
  222. FUNCTION.varchar.udf_fs_ReadFileAsString
  223. FUNCTION.varchar.udf_GetAppDefault
  224. FUNCTION.varchar.udf_GetAppDefault2
  225. FUNCTION.varchar.udf_GetBaseDir
  226. FUNCTION.varchar.udf_GetParmByNum
  227. FUNCTION.varchar.udf_GetProcessFlag
  228. FUNCTION.varchar.udf_getTempName
  229. FUNCTION.varchar.udf_getTempName_Identifier
  230. FUNCTION.varchar.udf_GetValidPortionOfDate
  231. FUNCTION.varchar.udf_index_name_suggested
  232. FUNCTION.varchar.udf_IsNull
  233. FUNCTION.varchar.udf_loan_Reasons_bitstring
  234. FUNCTION.varchar.udf_lstrip
  235. FUNCTION.varchar.udf_PadPrefix
  236. FUNCTION.varchar.udf_PostFixToRemove
  237. FUNCTION.varchar.udf_PPT_PrimaryKeys
  238. FUNCTION.varchar.udf_PrefixIfNotFound
  239. FUNCTION.varchar.udf_Registry_ReadValue
  240. FUNCTION.varchar.udf_rstrip
  241. FUNCTION.varchar.udf_sec_get_login_name
  242. FUNCTION.varchar.udf_srvr_HostName
  243. FUNCTION.varchar.udf_str_AppendI fNotFound
  244. FUNCTION.varchar.udf_str_csv_database_list
  245. FUNCTION.varchar.udf_str_csv_periods
  246. FUNCTION.varchar.udf_str_database_auto_list
  247. FUNCTION.varchar.udf_str_filename_as_zipname
  248. FUNCTION.varchar.udf_str_filename_strip_extension
  249. FUNCTION.varchar.udf_str_FileNameFromPath
  250. FUNCTION.varchar.udf_str_first_n_items
  251. FUNCTION.varchar.udf_str_first_n_items_new
  252. FUNCTION.varchar.udf_str_fmt_Address
  253. FUNCTION.varchar.udf_str_fmt_filename_unc
  254. FUNCTION.varchar.udf_str_fmt_money
  255. FUNCTION.varchar.udf_str_fmt_path_dest
  256. FUNCTION.varchar.udf_str_fmt_phone
  257. FUNCTION.varchar.udf_str_fmt_quotes_data_type
  258. FUNCTION.varchar.udf_str_fmt_quotes_dos_bat_file
  259. FUNCTION.varchar.udf_str_fmt_quotes_sqlvar
  260. FUNCTION.varchar.udf_str_fmt_sql
  261. FUNCTION.varchar.udf_str_fmt_sql_for_dos_bat_file
  262. FUNCTION.varchar.udf_str_fmt_SSN
  263. FUNCTION.varchar.udf_str_fmt_SSRSURL
  264. FUNCTION.varchar.udf_str_fmt_unc_filename_as_local
  265. FUNCTION.varchar.u df_str_fmt2
  266. FUNCTION.varchar.udf_str_fmtFilePath
  267. FUNCTION.varchar.udf_str_format_object_name
  268. FUNCTION.varchar.udf_str_format_table_name
  269. FUNCTION.varchar.udf_str_Format_TableName
  270. FUNCTION.varchar.udf_str_FormatAddress
  271. FUNCTION.varchar.udf_str_FormatInString
  272. FUNCTION.varchar.udf_str_FormatInString2
  273. FUNCTION.varchar.udf_str_FormatLikeString
  274. FUNCTION.varchar.udf_str_FormatLikeString2
  275. FUNCTION.varchar.udf_str_FormatLikeString3
  276. FUNCTION.varchar.udf_str_FormatLinkedServerName
  277. FUNCTION.varchar.udf_str_FormatName
  278. FUNCTION.varchar.udf_str_FormatQuoteString
  279. FUNCTION.varchar.udf_str_FormatServerName
  280. FUNCTION.varchar.udf_str_get_connection_string
  281. FUNCTION.varchar.udf_str_GetDateRange
  282. FUNCTION.varchar.udf_str_GetDriveFromPath
  283. FUNCTION.varchar.udf_str_GetExtensionFromPath
  284. FUNCTION.varchar.udf_str_GetFileNameFromPath
  285. FUNCTION.varchar.udf_str_GetNthParm
  286. FUNCTION.varchar.udf_str_GetServerName
  287. FUNCTION.varc har.udf_str_GetTempName
  288. FUNCTION.varchar.udf_str_getTempName_Identifier
  289. FUNCTION.varchar.udf_str_IsNumericOnly
  290. FUNCTION.varchar.udf_str_IsZeroLength
  291. FUNCTION.varchar.udf_str_lstrip
  292. FUNCTION.varchar.udf_str_PadPostfix
  293. FUNCTION.varchar.udf_str_PadPrefix
  294. FUNCTION.varchar.udf_str_ParentDirFromFullPathFileName
  295. FUNCTION.varchar.udf_str_PostfixOfLastOccurance
  296. FUNCTION.varchar.udf_str_ProperCase
  297. FUNCTION.varchar.udf_str_quotes_add
  298. FUNCTION.varchar.udf_str_replace_chars
  299. FUNCTION.varchar.udf_str_ReplaceChars
  300. FUNCTION.varchar.udf_str_ReplacePattern
  301. FUNCTION.varchar.udf_str_ReplacePattern_wip
  302. FUNCTION.varchar.udf_str_ReplacePatterns_wip
  303. FUNCTION.varchar.udf_str_ReplacePostfixOf
  304. FUNCTION.varchar.udf_str_rstrip
  305. FUNCTION.varchar.udf_str_ServerFromPath
  306. FUNCTION.varchar.udf_str_SPrintf
  307. FUNCTION.varchar.udf_str_srvr_auto_list
  308. FUNCTION.varchar.udf_str_StringAsAscii
  309. FUNCTION.varchar.udf_str_strip_non_alpha
  310. FUNCTION.varchar.udf_str_strip_non_alpha_with_excludes
  311. FUNCTION.varchar.udf_str_strip_numeric
  312. FUNCTION.varchar.udf_str_strip_quotes
  313. FUNCTION.varchar.udf_str_StripAphaAndNumeric
  314. FUNCTION.varchar.udf_str_StripAphaChars
  315. FUNCTION.varchar.udf_str_StripChars
  316. FUNCTION.varchar.udf_str_StripExtendedChars
  317. FUNCTION.varchar.udf_str_StripExtesionFromFileName
  318. FUNCTION.varchar.udf_str_StripFileNameFromPath
  319. FUNCTION.varchar.udf_str_StripNonAlphaChars
  320. FUNCTION.varchar.udf_str_StripServerAndFilenameFromPath
  321. FUNCTION.varchar.udf_str_StripServerFromPath
  322. FUNCTION.varchar.udf_str_SystemTableDefinition
  323. FUNCTION.varchar.udf_str_TableColumnDiff
  324. FUNCTION.varchar.udf_str_TableColumnDiff_Old
  325. FUNCTION.varchar.udf_str_trim
  326. FUNCTION.varchar.udf_str_trim2
  327. FUNCTION.varchar.udf_str_value_if_true
  328. FUNCTION.varchar.udf_str_xml_value
  329. FUNCTION.varchar.udf_strip
  330. FUNCTION.varchar.udf_strip_clean_filename
  331. FUNCTION.varchar.udf_stri p_clean_SessionName
  332. FUNCTION.varchar.udf_StripAphaChars
  333. FUNCTION.varchar.udf_StripChars
  334. FUNCTION.varchar.udf_StripNonAlphaChars
  335. FUNCTION.varchar.udf_StripQuotes
  336. FUNCTION.varchar.udf_StripTableColumnPrefix
  337. FUNCTION.varchar.udf_strIsNull
  338. FUNCTION.varchar.udf_strIsZeroLength
  339. FUNCTION.varchar.udf_strNumberWithPostfix
  340. FUNCTION.varchar.udf_sys_constraints
  341. FUNCTION.varchar.udf_sys_PrimaryKeys
  342. FUNCTION.varchar.udf_table_rec_unique_id
  343. FUNCTION.varchar.udf_Trim
  344. FUNCTION.varchar.udf_TrimAll
  345. FUNCTION.varchar.udf_wc_all_value
  346. FUNCTION.varchar.usp_AddQuoteChars
  347. FUNCTION.varchar.usp_pad_string
  348. FUNCTION.varchar.usp_str_fmt_filename
  349. FUNCTION.varchar.UTIL_GetParmByNum
  350. PROCEDURE.add_column
  351. PROCEDURE.AddEvent
  352. PROCEDURE.AddFilter
  353. PROCEDURE.ClearTrace
  354. PROCEDURE.CreateTrace
  355. PROCEDU RE.DirCreate
  356. PROCEDURE.DirInfo
  357. PROCEDURE.DirMove
  358. PROCEDURE.DirRemove
  359. PROCEDURE.DirTree
  360. PROCEDURE.FileCopy
  361. PROCEDURE.FileDelete
  362. PROCEDURE.FileExist
  363. PROCEDURE.FileInfo
  364. PROCEDURE.FileMove
  365. PROCEDURE.FileRename
  366. PROCEDURE.FindObject_usp
  367. PROCEDURE.FixedDrives2
  368. PROCEDURE.GetEnvironment
  369. PROCEDURE.prCheckRecentCache
  370. PROCEDURE.prMemusageRecord
  371. PROCEDURE.StartTrace
  372. PROCEDURE.StopTrace
  373. PROCEDURE.stp_Exec
  374. PROCEDURE.stp_foreach_examples
  375. PROCEDURE.stp_fs_SplitFileName
  376. PROCEDURE.stp_GetDateRange
  377. PROCEDURE.stp_GetTableColumnList
  378. PROCEDURE.stp_InitUserInput
  379. PROCEDURE.stp_InitUserInputMonthly
  380. PROCEDURE.stp_LogIndexes
  381. PROCEDURE.stp_LogProcess
  382. PROCEDURE.stp_LogProcess_Example
  383. PROCEDURE.stp_nrSpidByStatus
  384. PROCEDURE.stp_RebuildSavedIndexes
  385. PROCEDURE.stp_RunJob
  386. PROCEDURE.stp_SavenDropIndexes
  387. PROCEDURE.stp_ScriptDBName2Databases
  388. PROCEDURE.stp_ScriptDBName2Jobs
  389. PROCEDURE.stp_Sear chIndexHist
  390. PROCEDURE.stp_ShowCodeLine
  391. PROCEDURE.stp_ShowDuplicateIndexes2
  392. PROCEDURE.stp_ShowIndexes
  393. PROCEDURE.stp_SMTPMail
  394. PROCEDURE.stp_Trace
  395. PROCEDURE.stp_Trace_Blackbox
  396. PROCEDURE.stp_Trace_Cache
  397. PROCEDURE.stp_Trace_Identify_database_stored_procedure_calls
  398. PROCEDURE.stp_Trace_Identify_deadlocks
  399. PROCEDURE.stp_Trace_Identify_specific_error
  400. PROCEDURE.stp_Trace_Identify_stored_procedure_recompilations
  401. PROCEDURE.stp_Trace_Identifying_long_running_stored_procedures
  402. PROCEDURE.stp_Trace_Monitor_Databases
  403. PROCEDURE.stp_Trace_ShowAll
  404. PROCEDURE.stp_Trace_tune_database
  405. PROCEDURE.stp_Trace_tune_database_ext
  406. PROCEDURE.stp_util_StrListToTable
  407. PROCEDURE.SubDirs
  408. PROCEDURE.usp_anomaly_detection_send
  409. PROCEDURE.usp_anonmaly_detection
  410. PROCEDURE.usp_ApplyIndexWizardScripts
  411. PROCEDURE.usp_attach_db_from_dir
  412. PROCEDURE.usp_AuditLog_BuildStructures
  413. PROCEDURE.usp_AuditLog_PopulateFromDaily
  414. PROCEDURE.usp_CalcSpaceUsed
  415. PROCEDURE.usp_CheckForMaxDate
  416. PROCEDURE.usp_compare_tables
  417. PROCEDURE.usp_config_change_db_collation
  418. PROCEDURE.usp_config_olap_user
  419. PROCEDURE.usp_config_test_procs
  420. PROCEDURE.usp_CreateJobFromScript
  421. PROCEDURE.usp_CreateOneStepJob
  422. PROCEDURE.usp_createtable_tblInformationSchemaViews
  423. PROCEDURE.usp_createtable_tblInformationSchemaViewsNoTrig
  424. PROCEDURE.usp_CreateThreeStepJob
  425. PROCEDURE.usp_db_AppDefault_defaults_load
  426. PROCEDURE.usp_db_AppDefault_defaults_save
  427. PROCEDURE.usp_db_assembly_alter
  428. PROCEDURE.usp_db_assembly_ex ample
  429. PROCEDURE.usp_db_backups_missing_notification
  430. PROCEDURE.usp_DB_BackupTable
  431. PROCEDURE.usp_db_clr_deploy
  432. PROCEDURE.usp_db_clr_drop
  433. PROCEDURE.usp_db_createstats
  434. PROCEDURE.usp_db_CreateViewWithColumnNames
  435. PROCEDURE.usp_db_dbatoolstrace_synonyms_create
  436. PROCEDURE.usp_db_dependancies
  437. PROCEDURE.usp_db_diagrams_export
  438. PROCEDURE.usp_db_EMailData
  439. PROCEDURE.usp_db_ExportTable
  440. PROCEDURE.usp_db_ExportTables
  441. PROCEDURE.usp_db_ExportTableWithColumnNames
  442. PROCEDURE.usp_db_ForeignKeyConstraints_drop
  443. PROCEDURE.usp_db_fragmentation_load
  444. PROCEDURE.usp_db_GenerateInsertsScripts
  445. PROCEDURE.usp_db_GetDBFiles
  446. PROCEDURE.usp_db_GetRowSize
  447. PROCEDURE.usp_db_GetTableColumnList
  448. PROCEDURE.usp_db_GrantPermissions
  449. PROCEDURE.usp_db_index_alter_remote
  450. PROCEDURE.usp_db_index _Usage
  451. PROCEDURE.usp_db_indexes_drop_all
  452. PROCEDURE.usp_db_indexes_duplicates
  453. PROCEDURE.usp_db_init_index_operational_stats
  454. PROCEDURE.usp_db_logfiles_restore
  455. PROCEDURE.usp_db_LogIndexes
  456. PROCEDURE.usp_db_maint_CheckDBAndRebuildIndexes
  457. PROCEDURE.usp_db_Make_MakeAllAuditLogTriggers
  458. PROCEDURE.usp_db_Make_MakeAllDataAccessProcedures
  459. PROCEDURE.usp_db_Make_MakeAllTableLoadProcedures
  460. PROCEDURE.usp_db_MakeAuditLogTrigger
  461. PROCEDURE.usp_db_MakeDeleteRecordProc
  462. PROCEDURE.usp_db_MakeInsertRecordProc
  463. PROCEDURE.usp_db_MakeSelectRecordProc
  464. PROCEDURE.usp_db_MakeUpdateRecordProc
  465. PROCEDURE.usp_db_md_TableRowCount_Update
  466. PROCEDURE.usp_db_meta_data_clear
  467. PROCEDURE.usp_db_object_dependencies
  468. PROCEDURE.usp_db_PopulateCodeTables
  469. PROCEDURE.usp_db_PrimaryKeys_drop_all
  470. PROCEDURE.usp_db_proc_AppDefault_Delete
  471. PROCEDURE.usp_db_proc_AppD efault_Insert
  472. PROCEDURE.usp_db_proc_AppDefault_Select
  473. PROCEDURE.usp_db_proc_AppDefault_Update
  474. PROCEDURE.usp_db_proc_AppDefault_UpdateOrInsert
  475. PROCEDURE.usp_db_proc_tblDocument_insert
  476. PROCEDURE.usp_db_proc_tblDocument_SaveToDisk
  477. PROCEDURE.usp_db_proc_tblServerIdentity_update
  478. PROCEDURE.usp_db_RebuildSavedIndexes
  479. PROCEDURE.usp_db_recover_suspect
  480. PROCEDURE.usp_db_RefreshViews
  481. PROCEDURE.usp_db_relationships_drop
  482. PROCEDURE.usp_db_RenameObject
  483. PROCEDURE.usp_db_restore
  484. PROCEDURE.usp_db_restore_db_and_logfiles
  485. PROCEDURE.usp_db_rowcount_populate
  486. PROCEDURE.usp_db_runscript
  487. PROCEDURE.usp_db_SavenDropIndexes
  488. PROCEDURE.usp_db_ScriptServer
  489. PROCEDURE.usp_db_selectivity_log
  490. PROCEDURE.usp_db_SetMode
  491. PROCEDURE.usp_db_ShowMissingPrimaryKeys
  492. PROCEDURE.usp_db_shrinkfile
  493. PROCEDURE.usp_db_shrinkfiles
  494. PROCEDURE.usp_db_shrinkLog
  495. PROCEDURE.usp_db_space_filegroup_wise
  496. PROCEDURE.usp_db_synonym_create
  497. PROC EDURE.usp_db_table_definition
  498. PROCEDURE.usp_db_table_dependent_procs
  499. PROCEDURE.usp_db_table_identities
  500. PROCEDURE.usp_db_table_rowcount
  501. PROCEDURE.usp_db_TableCounts
  502. PROCEDURE.usp_db_TableExists
  503. PROCEDURE.usp_db_tables_drop_empty
  504. PROCEDURE.usp_db_tables_rowcounts
  505. PROCEDURE.usp_db_tables_rowcounts_local
  506. PROCEDURE.usp_db_tables_rowcounts_monetary_tables
  507. PROCEDURE.usp_db_TableStats
  508. PROCEDURE.usp_db_TablesWithoutPrimaryKeys
  509. PROCEDURE.usp_db_tblDocument_insert
  510. PROCEDURE.usp_db_tblIndexRecommendation_archive
  511. PROCEDURE.usp_db_tblIndexRecommendation_refresh_from_archive
  512. PROCEDURE.usp_db_tblIndexRecommendationDataSet_AddIfNotFound
  513. PROCEDURE.usp_db_tblTablesLinked_update
  514. PROCEDURE.usp_db_tbltrigger_set
  515. PROCEDURE.usp_db_track_waitstats_2005
  516. PROCEDURE.usp_db_trig_set
  517. PROCEDURE.usp_db_trig_SetTriggers
  518. PROCEDURE.usp_db_trig_SetTriggerStatus
  519. PROCEDURE.usp_db_trig_status_set
  520. PROCEDURE.usp_db_trigall_set
  521. PROCEDURE.usp_db_trigger_ShowStatus
  522. PROCEDURE.usp_db_trigs_status_set
  523. PROCEDURE.usp_db_users_killall
  524. PROCEDURE.usp_db_util_ShrinkDatabases
  525. PROCEDURE.usp_db_view_primary_keys
  526. PROCEDURE.usp_db_ViewExists
  527. PROCEDURE.usp_dba_dependencies_find
  528. PROCEDURE.usp_debug_LogProcess
  529. PROCEDURE.usp_debug_show_non_contigious_columns
  530. PROCEDURE.usp_debug_TableSyncStuff
  531. PROCEDURE.usp_displayoaerrorinfo
  532. PROCEDURE.usp_DisplayProcParameters
  533. PROCEDURE.usp_dmo_db_collection_script
  534. PROCEDURE.usp_example_active_directory_load
  535. PROCEDURE.usp_example_backup_history
  536. PROCEDURE.usp_example_CommonTableExpressions
  537. PROCEDURE.usp_Example_CompareDBs
  538. PROCEDURE.usp_example_create_HTML_table
  539. PROCEDURE.usp_example_dynamic_sql_return_value
  540. PROCEDURE.usp_example_dynamic_sql_return_value_extended
  541. PROCEDURE.usp_example_encryption
  542. PROCEDURE.usp_example_encryption_certificate
  543. PROCEDURE.usp_example_encryption2
  544. PROCEDURE.usp_example_execute_as
  545. PROCEDURE.usp_Example_ExtendedProcs
  546. PROCEDURE.usp_example_filegroups_add
  547. PROCEDURE.usp_example_find_object
  548. PROCEDURE.usp_example_find_regular_expression
  549. PROCEDURE.usp_example_foreach
  550. PROCEDURE.usp_example_fs_Dirs
  551. PROCEDURE.usp_example_fs_ReadTextFile
  552. PROCEDURE.usp_Example_GettingMultipleRecordSetsintoaTable
  553. PROCEDURE.usp_Example_GettingMultipleRecordSetsintoaTable2
  554. PROCEDURE.usp_Example_information_schema_views
  555. PROCEDURE.usp_example_LoadXMLFromFile_Example
  556. PROCEDURE.usp_example_LoopThroughFiles
  557. PROCEDURE.usp_example_LoopThroughServerDatabaseTable
  558. PROCEDURE.usp_example_LoopThroughServers
  559. PROCEDURE.usp_example_loopThroughServersDatabasesAndTables
  560. PROCEDURE.usp_Example_LoopThroughTables
  561. PROCEDURE.usp_Example_LoopWithoutCursor
  562. PROCEDURE.usp_example_MSforeach_examples
  563. PROCEDURE.usp_example_MSforeach_worker_Extended
  564. PROCEDURE.usp_e xample_MSforeachdb_Except
  565. PROCEDURE.usp_example_MSforeachfk
  566. PROCEDURE.usp_example_MSforeachsproc
  567. PROCEDURE.usp_example_MSforeachtrigger
  568. PROCEDURE.usp_example_MSforeachview
  569. PROCEDURE.usp_example_openrowset
  570. PROCEDURE.usp_example_output
  571. PROCEDURE.usp_example_partitions_move
  572. PROCEDURE.usp_example_pivot
  573. PROCEDURE.usp_example_ranking_and_error_handling
  574. PROCEDURE.usp_example_registry_read_write
  575. PROCEDURE.usp_example_RIOrder
  576. PROCEDURE.usp_Example_ShowServerJobs
  577. PROCEDURE.usp_example_srvr_information
  578. PROCEDURE.usp_example_srvrall_procedure_change
  579. PROCEDURE.usp_example_srvrall_trace
  580. PROCEDURE.usp_Example_StoredProcedureOptimazation
  581. PROCEDURE.usp_example_table_partitions2
  582. PROCEDURE.usp_example_table_partitions3
  583. PROCEDURE.usp_example_triggers
  584. PROCEDURE.usp_example_user_accounts
  585. PROCEDURE.usp_example_xml
  586. PROCEDURE.usp_example_xml_2
  587. PROCEDURE.usp_exampled_srvr_executesql
  588. PROCEDURE.usp_examples_co nfig_user_security
  589. PROCEDURE.usp_Examples_DBA_MiscFunctionCalls
  590. PROCEDURE.usp_examples_partitions_create_dynamically
  591. PROCEDURE.usp_examples_system_tables
  592. PROCEDURE.usp_ExportTablesToDB
  593. PROCEDURE.usp_ExtractTableList_Update
  594. PROCEDURE.usp_fmt_CrossTab
  595. PROCEDURE.usp_fmt_crosstab_new
  596. PROCEDURE.usp_fs_AccessControlList_create
  597. PROCEDURE.usp_fs_AccessControlList_load
  598. PROCEDURE.usp_fs_append_OA
  599. PROCEDURE.usp_fs_AppendFile
  600. PROCEDURE.usp_fs_BCPFile
  601. PROCEDURE.usp_fs_clean_directories
  602. PROCEDURE.usp_fs_clean_directories_master
  603. PROCEDURE.usp_fs_ConvertFile_UnicodeToAnsi
  604. PROCEDURE.usp_fs_CopyDB
  605. PROCEDURE.usp_fs_CopyDBs
  606. PROCEDURE.usp_fs_CopyFiles
  607. PROCEDURE.usp_fs_CopyFilesByDate
  608. PROCEDURE.usp_fs_CreateTextFile
  609. PROCEDURE.usp_fs_DeleteFile
  610. PROCEDURE.usp_fs_DeleteFile_SysCmd
  611. PROCEDURE.usp_fs_Delete FileBySize
  612. PROCEDURE.usp_fs_DeleteFiles
  613. PROCEDURE.usp_fs_DeleteFiles_LimitSize
  614. PROCEDURE.usp_fs_DeleteFiles_list
  615. PROCEDURE.usp_fs_DeleteFiles_ListFile
  616. PROCEDURE.usp_fs_DeleteMatchingFromSourceDir
  617. PROCEDURE.usp_fs_Dir
  618. PROCEDURE.usp_fs_dir_size
  619. PROCEDURE.usp_fs_dir_size_log_ssrs
  620. PROCEDURE.usp_fs_dir_sizes
  621. PROCEDURE.usp_fs_DirectoryExists
  622. PROCEDURE.usp_fs_disk_cleanup_run
  623. PROCEDURE.usp_fs_diskalert
  624. PROCEDURE.usp_fs_diskspace_check
  625. PROCEDURE.usp_fs_DiskSpaceFree
  626. PROCEDURE.usp_fs_ExecuteDOSFile
  627. PROCEDURE.usp_fs_ExecuteSQLFromFile
  628. PROCEDURE.usp_fs_export
  629. PROCEDURE.usp_fs_export_zip_email
  630. PROCEDURE.usp_fs_file_write
  631. PROCEDURE.usp_fs_FileDetails
  632. PROCEDURE.usp_fs_FileExists
  633. PROCEDURE.usp_fs_FileExists_clr
  634. PROCEDURE.usp_fs_FileExists_syscmd
  635. PROCEDURE.usp_fs_FileExistsTemporal
  636. PROCEDURE.usp_fs_FolderSize
  637. PROCEDURE.usp_fs_FormatFileName
  638. PROCEDURE.usp_fs_ftp_dir_list
  639. PROCEDURE.usp_fs_ftp_file_download
  640. PROCEDURE.usp_fs_ftp_file_upload
  641. PROCEDURE.usp_fs_ftp_GetDir
  642. PROCEDURE.usp_fs_ftp_GetFile
  643. PROCEDURE.usp_fs_GetFileInfo
  644. PROCEDURE.usp_fs_GetFileInfo_clr
  645. PROCEDURE.usp_fs_GetFileInfo_SysCmd
  646. PROCEDURE.usp_fs_GetFileInfo_SysCmd_sub
  647. PROCEDURE.usp_fs_GetFileInfoFull
  648. PROCEDURE.usp_fs_GetFileInformation
  649. PROCEDURE.usp_fs_import_file
  650. PROCEDURE.usp_fs_import_files
  651. PROCEDURE.usp_fs_ImportMultipleFiles
  652. PROCEDURE.usp_fs_ImportMultipleFilesBCP
  653. PROCEDURE.usp_fs_InfoUnZipFiles
  654. PROCEDURE.usp_fs_InfoZipFiles
  655. PROCEDURE.usp_fs_LoadXMLFromFile
  656. PROCEDURE.usp_fs_MakeDir
  657. PROCEDURE.usp_fs_MakeDir_clr
  658. PROCEDURE.usp_fs_MakeDir_SysCmd
  659. PROCEDURE.usp_fs_move_subscriptions
  660. PROCEDURE.usp_fs_MoveFile
  661. PROCEDURE.usp_fs_MoveFile_clr
  662. PROCEDURE.usp_fs_MoveFile_SysCmd
  663. PROCEDURE.usp_fs_MoveFiles
  664. PROCEDURE.usp_fs_MoveFiles_clr
  665. PROCEDURE.usp_fs_MoveFiles_SysCmd
  666. PROCEDURE.usp_fs_MoveFilesByDate
  667. PROCEDURE.usp_fs_OA_Run
  668. PROCEDURE.usp_fs_ReadFile
  669. PROCEDURE.usp_fs_ReadTextFile
  670. PROCEDURE.usp_fs_RemoveDir
  671. PROCEDURE.usp_fs_RemoveDir_SysCmd
  672. PROCEDURE.usp_fs_RemoveOldFiles
  673. PROCEDURE.usp_fs_RenameDir
  674. PROCEDURE.usp_fs_RenameFile
  675. PROCEDURE.usp_fs_RenameFile_clr
  676. PROCEDURE.usp_fs_RenameFile_SysCmd
  677. PROCEDURE.usp_fs_RenameFiles
  678. PROCEDURE.usp_fs_RunDosCommand
  679. PROCEDURE.usp_fs_RunFromDisk
  680. PROCEDURE.usp_fs_ShowTextFile
  681. PROCEDURE.usp_fs_SplitFileName
  682. PROCEDURE.usp_fs_template
  683. PROCEDURE.usp_fs_UnZipFiles
  684. PROCEDURE.usp_fs_vbs_retrieve_IUSR_password
  685. PROCEDURE.usp_fs_WinUnZipFiles
  686. PROCEDURE.usp_fs_WinZipFiles
  687. PROCEDURE.usp_fs_wmi_defrag_drives_win2003
  688. PROCEDURE.usp_fs_wmi_defrag_drives_winxp
  689. PROCEDURE.usp_fs_wmi_NTEventLog_import
  690. PROCEDURE.usp_fs_wmi_processes
  691. PROCEDURE.usp_fs_wmi_remote_execute
  692. PROCEDURE.usp_fs_wmi_rpt_fragmentation
  693. PROCEDURE.usp_fs_wmi_spn_query
  694. PROCEDURE.usp_fs_WriteStringToFile
  695. PROCEDURE.usp_fs_zip_dir
  696. PROCEDURE.usp_fs_ZipFile_isEmpty
  697. PROCEDURE.usp_fs_ZipFiles
  698. PROCEDURE.usp_fs_ZipFiles_check
  699. PROCEDURE.usp_fs_ZipFiles_SevenZip
  700. PROCEDURE.usp_fs_ZipFiles_ZipNewDeleteOld
  701. PROCEDURE.usp_fs_ZipFilesBySize
  702. PROCEDURE.usp_fs_ZipFilesBySize_old
  703. PROCEDURE.usp_fs_ZipRenameAndMove
  704. PROCEDURE.usp_fs_ZipRenameExtract
  705. PROCEDURE.usp_GenerateScript
  706. PROCEDURE.usp_get_dbstats
  707. PROCEDURE.usp_GetDateRange
  708. PROCEDURE.usp_GetRowCounts
  709. PROCEDURE.usp_help_revlo gin
  710. PROCEDURE.usp_helpindex2
  711. PROCEDURE.usp_hexadecimal
  712. PROCEDURE.usp_html_format
  713. PROCEDURE.usp_IndexWizard_RunOnAllDatabases
  714. PROCEDURE.usp_InitUserInputMonthly
  715. PROCEDURE.usp_job_CheckRunningJobs
  716. PROCEDURE.usp_JobReport
  717. PROCEDURE.usp_LimitSize_ProcessLog
  718. PROCEDURE.usp_LimitSize_Trace_Table
  719. PROCEDURE.usp_ListConnections
  720. PROCEDURE.usp_ListObjects
  721. PROCEDURE.usp_ListProcedureParameters
  722. PROCEDURE.usp_listProcParams
  723. PROCEDURE.usp_load_database_all
  724. PROCEDURE.usp_load_database_table_load_order
  725. PROCEDURE.usp_load_database_tables
  726. PROCEDURE.usp_load_database_tables_load_order
  727. PROCEDURE.usp_load_tblSysAllViews
  728. PROCEDURE.usp_log_clear_FileSystemSupportCalls
  729. PROCEDURE.usp_log_CopyFilesOnce
  730. PROCEDURE.usp_log_FileCopy
  731. PROCEDURE.usp_LogIndexes
  732. PROCEDURE.usp_logshipping_WriteLog
  733. PROCEDURE.usp_maint_BackupDirectories
  734. PROCEDURE.usp_maint_BackupLog
  735. PROCEDURE.usp_maint_CopyLogShippingFiles
  736. PROCED URE.usp_maint_CreateLogShipDatabase
  737. PROCEDURE.usp_maint_scriptall
  738. PROCEDURE.usp_maint_ScriptDatabases
  739. PROCEDURE.usp_md_load_tblColumn
  740. PROCEDURE.usp_md_load_tblColumnXRef
  741. PROCEDURE.usp_md_load_tblDatabase
  742. PROCEDURE.usp_md_load_tblMDSysAllViews
  743. PROCEDURE.usp_md_load_tblSchemaXRefs
  744. PROCEDURE.usp_md_load_tblServers
  745. PROCEDURE.usp_md_load_tblTable
  746. PROCEDURE.usp_md_load_tblTableSyncAndtblTableXRef
  747. PROCEDURE.usp_md_load_tblTableXRef
  748. PROCEDURE.usp_md_set_SynTypeID_from_prod
  749. PROCEDURE.usp_md_tblColumnXRef_Delete
  750. PROCEDURE.usp_md_UploadTableLoadOrder
  751. PROCEDURE.usp_notification_Diskspace
  752. PROCEDURE.usp_notification_jobs_executing
  753. PROCEDURE.usp_pm_get_waitstats
  754. PROCEDURE.usp_pm_track_waitstats
  755. PROCEDURE.usp_rpt_compile_errors_modules
  756. PROCEDURE.usp_rpt_compile_errors_views
  757. PROCEDURE.usp_rpt_EMail_info
  758. PROCEDURE.usp_rpt_fmt_crosstab
  759. PROCEDURE.usp_rpt_fmt_crosstab_multi
  760. PROCEDURE.usp_rpt_InitUserInput
  761. PROCEDURE.usp_rpt_login_info
  762. PROCEDURE.usp_rpt_srvr_DisplayMemoryUsage
  763. PROCEDURE.usp_rpt_vw_characteristics
  764. PROCEDURE.usp_SavenDropIndexes
  765. PROCEDURE.usp_schema_servers_load
  766. PROCEDURE.usp_search_code
  767. PROCEDURE.usp_SendMail_AddNew
  768. PROCEDURE.usp_SendMail_Run
  769. PROCEDURE.usp_ShowAllTableInfo
  770. PROCEDURE.usp_sp_MSforeach_worker_Extended
  771. PROCEDURE.usp_sp_MSforeachdb_Except
  772. PROCEDURE.usp_srvr_accounts_list
  773. PROCEDURE.usp_srvr_alter_growth
  774. PROCEDURE.usp_srvr_autoshrink_set
  775. PROCEDURE.usp_srvr_backup_check_file_dates
  776. PROCEDURE.usp_srvr_backup_history_load
  777. PROCEDURE.usp_srvr_backup_history_update
  778. PROCEDURE.usp_srvr_backups_load_history
  779. PROCEDURE.usp_srvr_block
  780. PROCEDURE.usp_srvr_CheckSQLAgent
  781. PROCEDURE.usp_srvr_collation_show_non_standard
  782. PROCEDURE.usp_srvr_CompareDB
  783. PROCEDURE.usp_srvr_CompareXRefDatabases
  784. PROCEDURE. usp _srvr_config_accounts_system_000
  785. PROCEDURE.usp_srvr_config_accounts_system_001_SQL
  786. PROCEDURE.usp_srvr_config_accounts_system_002_NT
  787. PROCEDURE.usp_srvr_config_accounts_system_003_credential
  788. PROCEDURE.usp_srvr_config_accounts_system_004_proxy
  789. PROCEDURE.usp_srvr_config_accounts_system_alpha_NT
  790. PROCEDURE.usp_srvr_config_accounts_system_areis_NT
  791. PROCEDURE.usp_srvr_config_accounts_system_other
  792. PROCEDURE.usp_srvr_config_AdHocDistributedQueries
  793. PROCEDURE.usp_srvr_config_agentXPs
  794. PROCEDURE.usp_srvr_config_alert_replication_transactional_distributor
  795. PROCEDURE.usp_srvr_config_alerts_setup
  796. PROCEDURE.usp_srvr_config_autoexec
  797. PROCEDURE.usp_srvr_config_backup_directory_path
  798. PROCEDURE.usp_srvr_config_bcp_version_get
  799. PROCEDURE.usp_srvr_config_BrokerEndpoint
  800. PROCEDURE.usp_srvr_config_ChangeSQLServiceCredentialsAndRestart
  801. PROCEDURE.usp_srvr_config_ChangeTempTableCollation_Ver2000
  802. PROCEDURE.usp_srvr_config_clr_changedbo wner
  803. PROCEDURE.usp_srvr_config_clr_drop
  804. PROCEDURE.usp_srvr_config_clr_install
  805. PROCEDURE.usp_srvr_config_clr_new
  806. PROCEDURE.usp_srvr_config_credential
  807. PROCEDURE.usp_srvr_config_credentials
  808. PROCEDURE.usp_srvr_config_DBMail_001
  809. PROCEDURE.usp_srvr_config_DBMail_002_add_account
  810. PROCEDURE.usp_srvr_config_dbmail_add_account
  811. PROCEDURE.usp_srvr_config_dbmail_troubleshoot
  812. PROCEDURE.usp_srvr_config_directory
  813. PROCEDURE.usp_srvr_config_fix_user_login
  814. PROCEDURE.usp_srvr_config_fix_user_login_ext
  815. PROCEDURE.usp_srvr_config_information_general
  816. PROCEDURE.usp_srvr_config_job_add_default
  817. PROCEDURE.usp_srvr_config_job_add_maint_index_maintenance_local
  818. PROCEDURE.usp_srvr_config_jobs
  819. PROCEDURE.usp_srvr_config_jobs_misc1
  820. PROCEDURE.usp_srvr_config_jobs_misc2
  821. PROCEDURE.usp_srvr_config_jobs_notifications
  822. PROCEDURE.usp_srvr_config_jobs_traces
  823. PROCEDURE.usp_srvr_config_list_accounts
  824. PROCEDURE.usp_srvr_config_logons_sy stem
  825. PROCEDURE.usp_srvr_config_logons_windows
  826. PROCEDURE.usp_srvr_config_logsAndJobHistory
  827. PROCEDURE.usp_srvr_config_MSDTC
  828. PROCEDURE.usp_srvr_config_operators
  829. PROCEDURE.usp_srvr_config_options
  830. PROCEDURE.usp_srvr_config_path_log_dbengine
  831. PROCEDURE.usp_srvr_config_path_log_ssrs
  832. PROCEDURE.usp_srvr_config_proxy_account_logins
  833. PROCEDURE.usp_srvr_config_proxy_accounts
  834. PROCEDURE.usp_srvr_config_replication_publications
  835. PROCEDURE.usp_srvr_config_RestrictAnonymous
  836. PROCEDURE.usp_srvr_config_security
  837. PROCEDURE.usp_srvr_config_security_encryption_certificate
  838. PROCEDURE.usp_srvr_config_security_encryption_certificate_back
  839. PROCEDURE.usp_srvr_config_security_lockdown_database
  840. PROCEDURE.usp_srvr_config_security_lockdown_object
  841. PROCEDURE.usp_srvr_config_security_lockdown_public
  842. PROCEDURE.usp_srvr_config_security_lockdown_server
  843. PROCEDURE.usp_srvr_config_server
  844. PROCEDURE.usp_srvr_config_server_memory
  845. PROCEDURE. usp_srvr_config_SMO_DMO
  846. PROCEDURE.usp_srvr_config_SQLServiceCredentialsAndRestart
  847. PROCEDURE.usp_srvr_config_SQLVersion
  848. PROCEDURE.usp_srvr_config_system
  849. PROCEDURE.usp_srvr_config_system_access
  850. PROCEDURE.usp_srvr_config_tempdb_move
  851. PROCEDURE.usp_srvr_config_test
  852. PROCEDURE.usp_srvr_config_xp_cmdshell
  853. PROCEDURE.usp_srvr_configuration
  854. PROCEDURE.usp_srvr_configuration_registry_info
  855. PROCEDURE.usp_srvr_configuration_service_accounts_list
  856. PROCEDURE.usp_srvr_configuration_setup_path
  857. PROCEDURE.usp_srvr_configure
  858. PROCEDURE.usp_srvr_configure_dbatoolsDB
  859. PROCEDURE.usp_srvr_connections
  860. PROCEDURE.usp_srvr_connections_kill
  861. PROCEDURE.usp_srvr_CreatedAndRunJob
  862. PROCEDURE.usp_srvr_DatabaseTuningAdvisor_Run
  863. PROCEDURE.usp_srvr_db_alter_growth
  864. PROCEDURE.usp_srvr_db_attach
  865. PROCEDURE.usp_srvr_db_autoshrink_set
  866. PROCEDURE.usp_srvr_db_backup
  867. PROCEDURE.usp_srvr_db_backup_all
  868. PROCEDURE.usp_srvr_db_backup_and_sync
  869. PROCEDURE.usp_srvr_db_backup_DBATools
  870. PROCEDURE.usp_srvr_db_back up_missing_notification
  871. PROCEDURE.usp_srvr_db_checkdb
  872. PROCEDURE.usp_srvr_db_checkdb_rebuildindexes
  873. PROCEDURE.usp_srvr_db_create
  874. PROCEDURE.usp_srvr_db_detatch
  875. PROCEDURE.usp_srvr_db_drop
  876. PROCEDURE.usp_srvr_db_exports
  877. PROCEDURE.usp_srvr_db_file_info
  878. PROCEDURE.usp_srvr_db_file_info_load
  879. PROCEDURE.usp_srvr_db_file_shrink
  880. PROCEDURE.usp_srvr_db_file_size
  881. PROCEDURE.usp_srvr_db_foreign_keys
  882. PROCEDURE.usp_srvr_db_ForeignKeys
  883. PROCEDURE.usp_srvr_db_ForeignKeys_script
  884. PROCEDURE.usp_srvr_db_fragmentation
  885. PROCEDURE.usp_srvr_db_GetRowCounts
  886. PROCEDURE.usp_srvr_db_growth_monitor
  887. PROCEDURE.usp_srvr_db_growth_track_populate
  888. PROCEDURE.usp_srvr_db_index_alter
  889. PROCEDURE.usp_srvr_db_index_create
  890. PROCEDURE.usp_srvr_db_index_create_from_existing
  891. PROCEDURE.usp_srvr_db_index_delete
  892. P ROCEDURE.usp_srvr_db_index_duplicates
  893. PROCEDURE.usp_srvr_db_index_exists
  894. PROCEDURE.usp_srvr_db_index_length
  895. PROCEDURE.usp_srvr_db_index_map_databases
  896. PROCEDURE.usp_srvr_db_index_missing
  897. PROCEDURE.usp_srvr_db_index_missing_clustered
  898. PROCEDURE.usp_srvr_db_index_missing_clustered_candidates
  899. PROCEDURE.usp_srvr_db_index_missing_recomendations_calc
  900. PROCEDURE.usp_srvr_db_index_missing_recomendations_dmv
  901. PROCEDURE.usp_srvr_db_index_missing_recomendations_ext
  902. PROCEDURE.usp_srvr_db_index_not_used
  903. PROCEDURE.usp_srvr_db_index_recommended_alter
  904. PROCEDURE.usp_srvr_db_index_recommended_exists_set
  905. PROCEDURE.usp_srvr_db_index_rename
  906. PROCEDURE.usp_srvr_db_index_reorganize_rebuild
  907. PROCEDURE.usp_srvr_db_indexes
  908. PROCEDURE.usp_srvr_db_indexes_delete
  909. PROCEDURE.usp_srvr_db_indexes_hypothetical_delete
  910. PROCEDURE.usp_srvr_db_indexes_load
  911. PROCEDURE.usp_srvr_db_indexes_recommended_remove_deleted_databases
  912. PROCEDURE.usp_srvr_db_indexes_retrieve
  913. PROCEDURE.usp_srvr_db_indexes_retrieveAllDBs
  914. PROCEDURE.usp_srvr_db_info
  915. PROCEDURE.usp_srvr_db_list
  916. PROCEDURE.usp_srvr_db_litespeed_backup
  917. PROCEDURE.usp_srvr_db_logshipping_configure
  918. PROCEDURE.usp_srvr_db_logspace
  919. PROCEDURE.usp_srvr_db_maint_all
  920. PROCEDURE.usp_srvr_db_maint_backupup_all
  921. PROCEDURE.usp_srvr_db_maint_checkdb_all
  922. PROCEDURE.usp_srvr_db_maint_checkdb_rebuildindexes
  923. PROCEDURE.usp_srvr_db_modules_refresh
  924. PROCEDURE.usp_srvr_db_object_drop
  925. PROCEDURE.usp_srvr_db_object_exists
  926. PROCEDURE.usp_srvr_db_objects_refresh
  927. PROCEDURE.usp_srvr_db_olap_backup
  928. PROCEDURE.usp_srvr_db_option
  929. PROCEDURE.usp_srvr_db_options_get
  930. PROCEDURE.usp_srvr_db_options_set
  931. PROCEDURE.usp_srvr_db_owner_get
  932. PROCEDURE.usp_srvr_db_owner_set
  933. PROCEDURE.usp_srvr_db_PrimaryKeys
  934. PROCEDURE.usp_srvr_db_proc_recompile
  935. PROCEDURE.usp_srvr_db_proc_recompile_all
  936. PROCEDURE.usp_srvr_db_properties
  937. PROCEDURE.usp_srvr_db_recovery_script_generator
  938. PROCEDURE.usp_srvr_db_recovery_set
  939. PROCEDURE.usp_srvr_db_repair
  940. PROCEDURE.usp_srvr_db_restore
  941. PROCEDURE.usp_srvr_db_restore_msdb_master
  942. PROCEDURE.usp_srvr_db_ri_order
  943. PROCEDURE.usp_srvr_db_script_and_zip
  944. PROCEDURE.usp_srvr_db_security_permissions_ViewDefinition_grant
  945. PROCEDURE.usp_srvr_db_selectivity
  946. PROCEDURE.usp_srvr_db_SpaceUsed
  947. PROCEDURE.usp_srvr_db_statistics_delete
  948. PROCEDURE.usp_srvr_db_statistics_retrieve
  949. PROCEDURE.usp_srvr_db_statistics_update
  950. PROCEDURE.usp_srvr_db_synonym_create
  951. PROCEDURE.usp_srvr_db_synonym_drop
  952. PROCEDURE.usp_srvr_db_synonyms_configure_Audit Log
  953. PROCEDURE.usp_srvr_db_synonyms_configure_DBATools
  954. PROCEDURE.usp_srvr_db_synonyms_create
  955. PROCEDURE.usp_srvr_db_synonyms_create_dbatools
  956. PROCEDURE.usp_srvr_db_synonyms_create_dbatoolsdb
  957. PROCEDURE.usp_srvr_db_synonyms_create_dbatoolsTrace
  958. PROCEDURE.usp_srvr_db_synonyms_create_local
  959. PROCEDURE.usp_srvr_db_table_as_html
  960. PROCEDURE.usp_srvr_db_table_column_selectivity
  961. PROCEDURE.usp_srvr_db_table_column_type
  962. PROCEDURE.usp_srvr_db_table_compare
  963. PROCEDURE.usp_srvr_db_table_constraint_columns
  964. PROCEDURE.usp_srvr_db_table_constraint_key
  965. PROCEDURE.usp_srvr_db_table_constraints
  966. PROCEDURE.usp_srvr_db_table_create
  967. PROCEDURE.usp_srvr_db_table_data_exists
  968. PROCEDURE.usp_srvr_db_table_find
  969. PROCEDURE.usp_srvr_db_table_relational_integrity_missing
  970. PROCEDURE.usp_srvr_db_table_rowcounts_update
  971. PROCEDURE.usp_srvr_db_truncate_table
  972. PROCEDURE.usp_srvr_db_view_create
  973. PROCE DURE.usp_srvr_db_view_drop
  974. PROCEDURE.usp_srvr_db_views_delete_orphaned
  975. PROCEDURE.usp_srvr_db_views_refresh
  976. PROCEDURE.usp_srvr_db_views_validate
  977. PROCEDURE.usp_srvr_DBCompareObjects
  978. PROCEDURE.usp_srvr_DBCompareTables
  979. PROCEDURE.usp_srvr_dmv_optimizer_elapsed_time
  980. PROCEDURE.usp_srvr_EnableJob
  981. PROCEDURE.usp_srvr_error_add
  982. PROCEDURE.usp_srvr_error_print
  983. PROCEDURE.usp_srvr_errorlog
  984. PROCEDURE.usp_srvr_exec
  985. PROCEDURE.usp_srvr_exec_back
  986. PROCEDURE.usp_srvr_execresultset
  987. PROCEDURE.usp_srvr_executesql_rowcount
  988. PROCEDURE.usp_srvr_filegroups_list_objects
  989. PROCEDURE.usp_srvr_growth_monitor
  990. PROCEDURE.usp_srvr_index_defrag_notify
  991. PROCEDURE.usp_srvr_info_filestats
  992. PROCEDURE.usp_srvr_IsSQLAgentJobRunning
  993. PROCEDURE.usp_srvr_job_backups_disabled_notification
  994. PROCEDURE.usp_srvr_job_delete
  995. PROCEDURE.usp_srvr_Job_Enable
  996. PROCEDU RE.usp_srvr_job_errors
  997. PROCEDURE.usp_srvr_job_errors_load
  998. PROCEDURE.usp_srvr_job_execution_status
  999. PROCEDURE.usp_srvr_job_history
  1000. PROCEDURE.usp_srvr_job_info_load
  1001. PROCEDURE.usp_srvr_job_owner_set
  1002. PROCEDURE.usp_srvr_job_running_notification
  1003. PROCEDURE.usp_srvr_job_schedule
  1004. PROCEDURE.usp_srvr_job_start
  1005. PROCEDURE.usp_srvr_job_status
  1006. PROCEDURE.usp_srvr_job_stop
  1007. PROCEDURE.usp_srvr_Job_WaitUntilCompletion
  1008. PROCEDURE.usp_srvr_jobs
  1009. PROCEDURE.usp_srvr_jobs_config_target_server
  1010. PROCEDURE.usp_srvr_jobs_failed
  1011. PROCEDURE.usp_srvr_jobs_get_composite_info
  1012. PROCEDURE.usp_srvr_jobs_script
  1013. PROCEDURE.usp_srvr_JobSchedules_Enable
  1014. PROCEDURE.usp_srvr_linked_add
  1015. PROCEDURE.usp_srvr_linked_drop
  1016. PROCEDURE.usp_srvr_linkedserver_attach
  1017. PROCEDURE.usp_srvr_linkedserver_attach_or_drop_all
  1018. PROCEDURE.usp_srvr_linkedserver_CreateRemoteDBAToolsLinks
  1019. PROCEDURE.usp_srvr_linkedserver_drop
  1020. PROCEDURE.usp_srvr_ListLocalServers
  1021. PROCEDURE.usp_srvr_load_DBFileInfo
  1022. PROCEDURE.usp_srvr_LoadDTSPackages
  1023. PROCEDURE.usp_srvr_LoadPackageToServer
  1024. PROCEDURE.usp_srvr_log_display
  1025. PROCEDURE.usp_srvr_logins_sp_hexadecimal
  1026. PROCEDURE.usp_srvr_logons_system
  1027. PROCEDURE.usp_srvr_logons_windows
  1028. PROCEDURE.usp_srvr_LogShipping_Enable
  1029. PROCEDURE.usp_srvr_mail_data
  1030. PROCEDURE.usp_srvr_mail_send
  1031. PROCEDURE.usp_srvr_mail_send_filtered
  1032. PROCEDURE.usp_srvr_mail_send_simple
  1033. PROCEDURE.usp_srvr_mail_SQLNotify
  1034. PROCEDURE.usp_srvr_main_notification_sqlagent
  1035. PROCEDURE.usp_srvr_maint_all
  1036. PROCEDURE.usp_srvr_maint_notification_blocking
  1037. PROCEDURE.usp_srvr_maint_notification_blocking_sp_who
  1038. PROCEDURE.usp_srvr_maint_notification_cpu_usage
  1039. PROCEDURE.usp_srvr_maint_notification_DBSizeAlert
  1040. PROCEDURE.usp_srvr_maint_notification_diskspace
  1041. PROCEDURE.usp_srvr_maint_notification_fragmentation
  1042. PROCEDURE.usp_srvr_maint_notificat ion_jobs_disabled
  1043. PROCEDURE.usp_srvr_maint_notification_jobs_failed
  1044. PROCEDURE.usp_srvr_maint_notification_shutdown
  1045. PROCEDURE.usp_srvr_maint_notification_srvr_status
  1046. PROCEDURE.usp_srvr_maint_notification_users
  1047. PROCEDURE.usp_srvr_md_rowcounts_update
  1048. PROCEDURE.usp_srvr_memory
  1049. PROCEDURE.usp_srvr_MemoryStatus
  1050. PROCEDURE.usp_srvr_notification_disk_usage
  1051. PROCEDURE.usp_srvr_notification_tables_missing_clustered_indexes
  1052. PROCEDURE.usp_srvr_notification_tables_missing_primary_keys
  1053. PROCEDURE.usp_srvr_notification_tables_missing_referential_integrity
  1054. PROCEDURE.usp_srvr_notification_unique_record_constraints
  1055. PROCEDURE.usp_srvr_notify_users
  1056. PROCEDURE.usp_srvr_NTEventLog_LogParser_import
  1057. PROCEDURE.usp_srvr_object_find
  1058. PROCEDURE.usp_srvr_object_find_parameter
  1059. PROCEDURE.usp_srvr_operator_add
  1060. PROCEDURE.usp_srvr_OptionMonitor
  1061. PROCEDURE.usp_srvr_OptionMonitor_Original
  1062. P ROCEDURE.usp_srvr_osql
  1063. PROCEDURE.usp_srvr_partition_left_delete
  1064. PROCEDURE.usp_srvr_partition_right_add
  1065. PROCEDURE.usp_srvr_performance_issues
  1066. PROCEDURE.usp_srvr_performance_locks_show
  1067. PROCEDURE.usp_srvr_Populate_MemoryStatus
  1068. PROCEDURE.usp_srvr_registry_path
  1069. PROCEDURE.usp_srvr_registry_read
  1070. PROCEDURE.usp_srvr_registry_write
  1071. PROCEDURE.usp_srvr_rename
  1072. PROCEDURE.usp_srvr_rep_create_subscriber
  1073. PROCEDURE.usp_srvr_rep_create_subscribers
  1074. PROCEDURE.usp_srvr_rep_publication_create
  1075. PROCEDURE.usp_srvr_rep_publication_drop
  1076. PROCEDURE.usp_srvr_rep_sync_merge
  1077. PROCEDURE.usp_srvr_rep_sync_push
  1078. PROCEDURE.usp_srvr_rpt_events_ddl
  1079. PROCEDURE.usp_srvr_rpt_job_schedules
  1080. PROCEDURE.usp_srvr_rpt_srvr_connections
  1081. PROCEDURE.usp_srvr_rpt_srvr_surface_area_configuration
  1082. PROCEDURE.usp_srvr_rpts_deploy
  1083. PROCEDURE.usp_srvr_RunJo b
  1084. PROCEDURE.usp_srvr_RunPerfLog
  1085. PROCEDURE.usp_srvr_SavePackages
  1086. PROCEDURE.usp_srvr_schema_drop
  1087. PROCEDURE.usp_srvr_schema_procedures_migrate
  1088. PROCEDURE.usp_srvr_schema_routines_drop
  1089. PROCEDURE.usp_srvr_schema_synonyms_drop
  1090. PROCEDURE.usp_srvr_schema_views_drop
  1091. PROCEDURE.usp_srvr_script_alerts
  1092. PROCEDURE.usp_srvr_script_database_attach
  1093. PROCEDURE.usp_srvr_script_database_attaches
  1094. PROCEDURE.usp_srvr_script_database_create
  1095. PROCEDURE.usp_srvr_script_database_creates
  1096. PROCEDURE.usp_srvr_Script_Inserts
  1097. PROCEDURE.usp_srvr_script_logins
  1098. PROCEDURE.usp_srvr_script_operators
  1099. PROCEDURE.usp_srvr_script_table_inserts
  1100. PROCEDURE.usp_srvr_scriptall
  1101. PROCEDURE.usp_srvr_ScriptAllDatabases
  1102. PROCEDURE.usp_srvr_ScriptAllObjectsInDatabase
  1103. PROCEDURE.usp_srvr_ScriptObjects
  1104. PROCEDURE.usp_srvr_ScriptObjectsByType
  1105. PROCEDURE.usp_srvr_security_accounts
  1106. PROCEDURE.usp_srvr_security_accts_drop
  1107. PROCEDURE.usp_srvr_security_ac cts_drop_by_principal
  1108. PROCEDURE.usp_srvr_security_accts_test
  1109. PROCEDURE.usp_srvr_security_certificate_alter_change_pwd
  1110. PROCEDURE.usp_srvr_security_certificate_alter_change_pwd_encrypted
  1111. PROCEDURE.usp_srvr_security_certificate_alter_import_pkey_existing
  1112. PROCEDURE.usp_srvr_security_certificate_alter_password_to_dbmasterkey
  1113. PROCEDURE.usp_srvr_security_certificate_backup_to_file
  1114. PROCEDURE.usp_srvr_security_certificate_backup_to_file_privatekey_encrypt
  1115. PROCEDURE.usp_srvr_security_certificate_backup_to_file_privatekey_encrypted
  1116. PROCEDURE.usp_srvr_security_certificate_create_fromassembly
  1117. PROCEDURE.usp_srvr_security_certificate_create_fromfile
  1118. PROCEDURE.usp_srvr_security_certificate_create_fromsignedexecutable
  1119. PROCEDURE.usp_srvr_security_certificate_create_selfsigned
  1120. PROCEDURE.usp_srvr_security_certificate_drop
  1121. PROCEDURE.usp_srvr_security_certificate_grant_control
  1122. PROCEDURE.usp_srvr_security_certificate_selfsigned_cre ate
  1123. PROCEDURE.usp_srvr_security_clone_db_user
  1124. PROCEDURE.usp_srvr_security_clone_user_db_all
  1125. PROCEDURE.usp_srvr_security_credential_create
  1126. PROCEDURE.usp_srvr_security_credential_drop
  1127. PROCEDURE.usp_srvr_security_credential_map_login
  1128. PROCEDURE.usp_srvr_security_credential_update
  1129. PROCEDURE.usp_srvr_security_examples
  1130. PROCEDURE.usp_srvr_security_iuser_password
  1131. PROCEDURE.usp_srvr_security_key_clr_map_login_GrantUNSAFE
  1132. PROCEDURE.usp_srvr_security_key_databasemaster
  1133. PROCEDURE.usp_srvr_security_key_encryption_drop
  1134. PROCEDURE.usp_srvr_security_key_service_backup
  1135. PROCEDURE.usp_srvr_security_key_servicemaster
  1136. PROCEDURE.usp_srvr_security_key_symetric_close
  1137. PROCEDURE.usp_srvr_security_key_symetric_create
  1138. PROCEDURE.usp_srvr_security_key_symetric_drop
  1139. PROCEDURE.usp_srvr_security_key_symetric_encrypt
  1140. PROCEDURE.usp_srvr_security_key_symetric_open
  1141. PROCEDURE.usp_srvr_security_local_groups
  1142. PROCEDURE.usp_srvr_security _login_credential_map
  1143. PROCEDURE.usp_srvr_security_login_objects_owned
  1144. PROCEDURE.usp_srvr_security_logininfo
  1145. PROCEDURE.usp_srvr_security_permission_object_changeOwner
  1146. PROCEDURE.usp_srvr_security_permissions
  1147. PROCEDURE.usp_srvr_security_permissions_check
  1148. PROCEDURE.usp_srvr_security_permissions_db_executor_update
  1149. PROCEDURE.usp_srvr_security_permissions_ExecGrantViewDefinition
  1150. PROCEDURE.usp_srvr_security_principal_create
  1151. PROCEDURE.usp_srvr_security_principal_update
  1152. PROCEDURE.usp_srvr_security_proxy_add
  1153. PROCEDURE.usp_srvr_security_proxy_configure
  1154. PROCEDURE.usp_srvr_security_proxy_delete
  1155. PROCEDURE.usp_srvr_security_proxy_login_grant
  1156. PROCEDURE.usp_srvr_security_proxy_subsystem_grant
  1157. PROCEDURE.usp_srvr_security_proxy_update
  1158. PROCEDURE.usp_srvr_security_RetrievePermissions
  1159. PROCEDURE.usp_srvr_security_role_members
  1160. PROCEDURE.usp_srvr_security_role_members_drop
  1161. PROCED URE.usp_srvr_security_roles
  1162. PROCEDURE.usp_srvr_security_roles_db
  1163. PROCEDURE.usp_srvr_security_server_principal_owns_database_objects
  1164. PROCEDURE.usp_srvr_security_show
  1165. PROCEDURE.usp_srvr_security_users
  1166. PROCEDURE.usp_srvr_security_users_orphans
  1167. PROCEDURE.usp_srvr_security_WinNTUser_create
  1168. PROCEDURE.usp_srvr_service
  1169. PROCEDURE.usp_srvr_service_sqlserver
  1170. PROCEDURE.usp_srvr_shrink_all_databases
  1171. PROCEDURE.usp_srvr_shrinkfiles
  1172. PROCEDURE.usp_srvr_spid
  1173. PROCEDURE.usp_srvr_SQLAgent_status
  1174. PROCEDURE.usp_srvr_SQLAgent_status_update
  1175. PROCEDURE.usp_srvr_sqlcmd
  1176. PROCEDURE.usp_srvr_ssrs_datasource_read
  1177. PROCEDURE.usp_srvr_ssrs_datasourcename_update
  1178. PROCEDURE.usp_srvr_ssrs_deploy_datamodels
  1179. PROCEDURE.usp_srvr_ssrs_deploy_datasources
  1180. PROCEDURE.usp_srvr_ssrs_deploy_datasources_back
  1181. PROCEDURE.usp_srvr_ssrs_deploy_reports
  1182. PROCEDURE.usp_srvr_ssrs_deploy_reports_back
  1183. PROCEDURE.usp_srvr_ssrs_download_object
  1184. PROCEDUR E.usp_srvr_ssrs_import
  1185. PROCEDURE.usp_srvr_ssrs_rpt_read
  1186. PROCEDURE.usp_srvr_ssrs_rpt_ReportErrors
  1187. PROCEDURE.usp_srvr_ssrs_tblSSRSReports_DataSources
  1188. PROCEDURE.usp_srvr_ssrs_version
  1189. PROCEDURE.usp_srvr_startup_display
  1190. PROCEDURE.usp_srvr_startup_log
  1191. PROCEDURE.usp_srvr_statistics
  1192. PROCEDURE.usp_srvr_statistics_create_missing
  1193. PROCEDURE.usp_srvr_statistics_create_missing_AllDBs
  1194. PROCEDURE.usp_srvr_statistics_delete
  1195. PROCEDURE.usp_srvr_statistics_duplicates_show
  1196. PROCEDURE.usp_srvr_statistics_load
  1197. PROCEDURE.usp_srvr_statistics_retrieve
  1198. PROCEDURE.usp_srvr_statistics_retrieve_missing
  1199. PROCEDURE.usp_srvr_statistics_show
  1200. PROCEDURE.usp_srvr_stats_ShowIO
  1201. PROCEDURE.usp_srvr_status
  1202. PROCEDURE.usp_srvr_status_update
  1203. PROCEDURE.usp_srvr_StopService
  1204. PROCEDURE.usp_srvr_sync_table_data
  1205. PROCEDURE.usp_srvr_sysmail_views
  1206. PROCEDURE.usp_srvr_table_row_counts
  1207. P ROCEDURE.usp_srvr_table_row_counts_all_srvrs
  1208. PROCEDURE.usp_srvr_trace_activity
  1209. PROCEDURE.usp_srvr_trace_add_event
  1210. PROCEDURE.usp_srvr_Trace_All
  1211. PROCEDURE.usp_srvr_trace_all_srvrs
  1212. PROCEDURE.usp_srvr_trace_cpu
  1213. PROCEDURE.usp_srvr_trace_CPU_Bottlenecks
  1214. PROCEDURE.usp_srvr_trace_CPU_cached_batches_or_procedures
  1215. PROCEDURE.usp_srvr_trace_data_counts
  1216. PROCEDURE.usp_srvr_trace_default
  1217. PROCEDURE.usp_srvr_trace_disable
  1218. PROCEDURE.usp_srvr_trace_DMVs
  1219. PROCEDURE.usp_srvr_trace_DropHypotheticalIndexes
  1220. PROCEDURE.usp_srvr_trace_enable
  1221. PROCEDURE.usp_srvr_trace_ImportFiles
  1222. PROCEDURE.usp_srvr_trace_index_usage
  1223. PROCEDURE.usp_srvr_Trace_Insert
  1224. PROCEDURE.usp_srvr_trace_LongRunningProcs
  1225. PROCEDURE.usp_srvr_trace_monitor
  1226. PROCEDURE.usp_srvr_trace_perf_cpu_ave
  1227. PROCEDURE.usp_srvr_trace_perf_cpu_tot
  1228. PROCEDURE.usp_srvr_trace_perf_sess ions_all
  1229. PROCEDURE.usp_srvr_trace_ProcedureCacheUsage
  1230. PROCEDURE.usp_srvr_trace_recompile_events
  1231. PROCEDURE.usp_srvr_trace_reports_send
  1232. PROCEDURE.usp_srvr_trace_running_show
  1233. PROCEDURE.usp_srvr_trace_show_CPUIntensive
  1234. PROCEDURE.usp_srvr_trace_show_errors
  1235. PROCEDURE.usp_srvr_trace_showAll
  1236. PROCEDURE.usp_srvr_trace_showTraceFileContents
  1237. PROCEDURE.usp_srvr_trace_sp_monitor
  1238. PROCEDURE.usp_srvr_trace_sp_who
  1239. PROCEDURE.usp_srvr_trace_sp_who2
  1240. PROCEDURE.usp_srvr_trace_spid
  1241. PROCEDURE.usp_srvr_trace_srvr
  1242. PROCEDURE.usp_srvr_trace_srvr_once
  1243. PROCEDURE.usp_srvr_trace_stopall
  1244. PROCEDURE.usp_srvr_trace_table_limit_size
  1245. PROCEDURE.usp_srvr_trace_tablediff
  1246. PROCEDURE.usp_srvr_trace_waiting_tasks
  1247. PROCEDURE.usp_srvr_trigger_ShowStatus
  1248. PROCEDURE.usp_srvr_users_kill_dead_spid
  1249. PROCEDURE.usp_srvr_util_IndexWizard_Run
  1250. PROCEDURE.usp_srvr_webpage_create
  1251. PROCEDURE.usp_srvr_xp_cmdshell
  1252. PROCEDURE.usp_srvr_xp_cmdshell_prox y_pwd_set
  1253. PROCEDURE.usp_srvr_xp_cmdshell_proxy_pwd_set_all
  1254. PROCEDURE.usp_srvr_xp_cmdshell_sqlcmd
  1255. PROCEDURE.usp_srvr_xp_cmdshell_v2
  1256. PROCEDURE.usp_srvr2k_maint_index_defrag_all_dbs
  1257. PROCEDURE.usp_srvr2k_maint_index_defrag_dbs
  1258. PROCEDURE.usp_srvrall
  1259. PROCEDURE.usp_srvrall_db_backups_missing_notification
  1260. PROCEDURE.usp_srvrall_db_execute
  1261. PROCEDURE.usp_srvrall_db_execute_osql
  1262. PROCEDURE.usp_srvrall_db_execute_sql
  1263. PROCEDURE.usp_srvrall_db_indexes_hypothetical_delete
  1264. PROCEDURE.usp_srvrall_db_table_find
  1265. PROCEDURE.usp_srvrall_fs_defrag_drives_win2003
  1266. PROCEDURE.usp_srvrall_fs_drive_info
  1267. PROCEDURE.usp_srvrall_index_alter
  1268. PROCEDURE.usp_srvrall_index_fragmentation_load
  1269. PROCEDURE.usp_srvrall_index_length
  1270. PROCEDURE.usp_srvrall_index_retrieve
  1271. PROCEDURE.usp_srvrall_job_enable
  1272. PROCEDURE.usp_srvrall_job_help
  1273. PROCEDURE.usp_srvrall_job_list
  1274. PROCEDURE.usp_srvrall_job_sp_help_job_activity
  1275. PROCEDURE.usp_srvrall_jo b_start
  1276. PROCEDURE.usp_srvrall_job_status
  1277. PROCEDURE.usp_srvrall_jobs_get_composite_info
  1278. PROCEDURE.usp_srvrall_jobs_sync_enabled
  1279. PROCEDURE.usp_srvrall_jobs_trace_enable
  1280. PROCEDURE.usp_srvrall_maint_index_defrag_all_dbs
  1281. PROCEDURE.usp_srvrall_query_performance_misc
  1282. PROCEDURE.usp_srvrall_security_accts_drop
  1283. PROCEDURE.usp_srvrall_trace_load_tblTracePerfSessionsAll
  1284. PROCEDURE.usp_srvrall_trace_sp_who_load
  1285. PROCEDURE.usp_srvrall_trace_sp_who2_load
  1286. PROCEDURE.usp_srvrall_warnings
  1287. PROCEDURE.usp_ssrs_deployment_scripts
  1288. PROCEDURE.usp_ssrs_example1
  1289. PROCEDURE.usp_ssrs_xml_read
  1290. PROCEDURE.usp_str_SingleColumnTableToDelimitedList
  1291. PROCEDURE.usp_str_SplitString
  1292. PROCEDURE.usp_svr_db_compare_sysviews
  1293. PROCEDURE.usp_svr_retrieveIndexes
  1294. PROCEDURE.usp_sys_AppDefault
  1295. PROCEDURE.usp_sys_config_appdefault
  1296. PROCEDURE.usp_sys_constraints
  1297. PROCEDURE.usp_tblDatabaseFile_config_update
  1298. PROCEDURE.usp_tblDatabaseFile_config_upd ate_auto
  1299. PROCEDURE.usp_trace_setfilter
  1300. PROCEDURE.usp_traceflag_autostats
  1301. PROCEDURE.usp_TraceFlags_Init
  1302. PROCEDURE.usp_TraceTable_Create
  1303. PROCEDURE.usp_UseOA
  1304. PROCEDURE.usp_util_DropAllIndexes
  1305. PROCEDURE.usp_util_export
  1306. PROCEDURE.usp_util_foreign_keys_enable
  1307. PROCEDURE.usp_util_GetTempTableName
  1308. PROCEDURE.usp_util_TruncateLog
  1309. PROCEDURE.usp_xml_file_read
  1310. PROCEDURE.util_IntListToTable
  1311. PROCEDURE.WIP_usp_srvr_config_security_object_lockdown
  1312. PROCEDURE.wip_usp_srvr_db_insert_indexstats
  1313. PROCEDURE.usp_srvr_mail_send_as_html