use <DB>
go
-------------------------------------- AGG.SQL (ALL) -------------------------
sp_objectagg
go
sp_columnagg
go
sp_indexagg
go
sp_grantsagg
go
sp_tableagg
go
sp_typeagg
go
-------------------------------------- CST.SQL (ALL) -------------------------
sp_checksystables
go
-------------------------------------- DBA.SQL (PARTIAL) ---------------------
sp_freespace
go
sp_lockconfig
go
sp_loggedmsgs
go
sp_new
go
sp_newstats
go
sp_segmentdetail
go
sp_segments
go
sp_strategies
go
sp_thalist
go
sp_unused
go
-------------------------------------- GROUP.SQL (ALL) -----------------------
sp_groups               -- or equivalently sp_roles
go
sp_members
go
sp_sysroles
go
sp_userroles
go
-------------------------------------- INDEX.SQL (ALL) -----------------------
sp_indexes
go
sp_indexes2
go
sp_checkindexes
go
sp_selectivity
go
-------------------------------------- OBJECT.SQL (PARTIAL) ------------------
sp_arguments
go
sp_checks
go
sp_defaults
go
sp_procs
go
sp_rules
go
sp_tablesx
go
sp_triggers
go
sp_usertypes
go
sp_views
go
-------------------------------------- PKFK.SQL (ALL) ------------------------
sp_nullcolumns
go
sp_refkeys
go
sp_refkeysright
go
sp_refkeysx
go
-------------------------------------- PROTECT.SQL (PARTIAL) -----------------
sp_grantscreate
go
sp_grantsme
go
sp_grantsme        'columns,public'
go
-------------------------------------- RIGHT.SQL (ALL) -----------------------
sp_columnsunique
go
sp_domainsright
go
sp_groupsright
go
sp_objectsunique
go
sp_rolesright
go
sp_usesright
go
-------------------------------------- SIZE.SQL (PARTIAL) --------------------
sp_execsizes       900                  -- sysprocedures rows
go
sp_sizes           500                  -- pages
go
sp_spacebyuser
go
-------------------------------------- SOLARIS.SQL (ALL) ---------------------
sp_device          sysprocsdev
go
sp_device
go
sp_deviceright
go
sp_devicespace     agg
go
sp_devicespace
go
sp_fragments
go
sp_freedevice
go
sp_set
go
sp_set             X
go
-------------------------------------- SYSTEM.SQL (PARTIAL) ------------------
sp_db
go
sp_db              date
go
sp_db              logdate
go
sp_db              size
go
sp_blockers
go
sp_busy
go
sp_cache
go
sp_remotelogins
go
sp_remoteservers
go
sp_status
go
sp_alllocks
go
sp_lockagg
go
sp_locking
go
-------------------------------------- TREE.SQL (PARTIAL) --------------------
sp_backexecall
go
sp_roletrees
go
sp_trees
go
-------------------------------------- UTILITY.SQL (PARTIAL) -----------------
sp_add             55555, 96734532, 543426, 55
go
sp_date
go
sp_date            X
go
sp_me
go
sp_server
go
sp_units           1000
go
-------------------------------------- XREF.SQL (PARTIAL)---------------------
sp_defaultcols
go
sp_identity
go
sp_loginwhere      guest
go
sp_ruleuse
go
-------------------------------------- USERS.SQL (ALL) -----------------------
sp_logins          status
go
sp_logins          usage
go
sp_users           alias
go
