SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2000
Microsoft SQL Server 2000
SQL Server 2000 Books Online
Transact-SQL Reference
System Stored Procedures
Object Hierarchy Syntax
sp_ActiveDirectory_Obj
sp_ActiveDirectory_SCP
sp_add_alert
sp_addalias
sp_addapprole
sp_add_data_file_recover_suspect_db
sp_addextendedproc
sp_addextendedproperty
sp_addgroup
sp_add_category
sp_add_job
sp_add_jobschedule
sp_add_jobserver
sp_add_jobstep
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_add_log_file_recover_suspect_db
sp_addlogin
sp_add_log_shipping_database
sp_add_log_shipping_plan
sp_add_log_shipping_plan_database
sp_add_log_shipping_primary
sp_add_log_shipping_secondary
sp_add_maintenance_plan
sp_add_maintenance_plan_db
sp_add_maintenance_plan_job
sp_addmessage
sp_add_notification
sp_add_operator
sp_addremotelogin
sp_addrole
sp_addrolemember
sp_addserver
sp_addsrvrolemember
sp_addtask
sp_addtype
sp_add_targetservergroup
sp_addumpdevice
sp_add_targetsvrgrp_member
sp_adduser
sp_altermessage
sp_apply_job_to_targets
sp_approlepassword
sp_attach_db
sp_attach_single_file_db
sp_autostats
sp_bindefault
sp_bindrule
sp_bindsession
sp_can_tlog_be_applied
sp_catalogs
sp_certify_removable
sp_change_monitor_role
sp_change_primary_role
sp_change_secondary_role
sp_change_users_login
sp_changedbowner
sp_changegroup
sp_changeobjectowner
sp_column_privileges
sp_column_privileges_ex
sp_columns
sp_columns_ex
sp_configure
sp_create_log_shipping_monitor_account
sp_create_removable
sp_createstats
sp_cursor_list
sp_cycle_errorlog
sp_databases
sp_datatype_info
sp_dbcmptlevel
sp_dbfixedrolepermission
sp_dboption
sp_dbremove
sp_defaultdb
sp_defaultlanguage
sp_define_log_shipping_monitor
sp_delete_alert
sp_delete_backuphistory
sp_delete_category
sp_delete_database_backuphistory
sp_delete_job
sp_delete_jobschedule
sp_delete_jobserver
sp_delete_jobstep
sp_delete_log_shipping_database
sp_delete_log_shipping_monitor_info
sp_delete_log_shipping_plan
sp_delete_log_shipping_plan_database
sp_delete_log_shipping_primary
sp_delete_log_shipping_secondary
sp_delete_maintenance_plan
sp_delete_maintenance_plan_db
sp_delete_maintenance_plan_job
sp_delete_notification
sp_delete_operator
sp_delete_targetserver
sp_delete_targetservergroup
sp_delete_targetsvrgrp_member
sp_denylogin
sp_depends
sp_describe_cursor
sp_describe_cursor_columns
sp_describe_cursor_tables
sp_detach_db
sp_dropalias
sp_dropapprole
sp_dropdevice
sp_dropextendedproc
sp_dropextendedproperty
sp_dropgroup
sp_droplinkedsrvlogin
sp_droplogin
sp_dropmessage
sp_dropremotelogin
sp_droprole
sp_droprolemember
sp_dropserver
sp_dropsrvrolemember
sp_droptask
sp_droptype
sp_dropuser
sp_dropwebtask
sp_enumcodepages
sp_executesql
sp_fkeys
sp_foreignkeys
sp_fulltext_catalog
sp_fulltext_column
sp_fulltext_database
sp_fulltext_service
sp_fulltext_table
sp_getapplock
sp_getbindtoken
sp_get_log_shipping_monitor_info
sp_grantdbaccess
sp_grantlogin
sp_help
sp_help_alert
sp_help_category
sp_helpconstraint
sp_helpdb
sp_helpdbfixedrole
sp_helpdevice
sp_help_downloadlist
sp_helpextendedproc
sp_helpfile
sp_helpfilegroup
sp_help_fulltext_catalogs
sp_help_fulltext_catalogs_cursor
sp_help_fulltext_columns
sp_help_fulltext_columns_cursor
sp_help_fulltext_tables
sp_help_fulltext_tables_cursor
sp_helpgroup
sp_helphistory
sp_help_job
sp_help_jobhistory
sp_help_jobschedule
sp_help_jobserver
sp_help_jobstep
sp_helpindex
sp_helplanguage
sp_helplinkedsrvlogin
sp_helplogins
sp_help_maintenance_plan
sp_help_notification
sp_helpntgroup
sp_help_operator
sp_helpremotelogin
sp_helprole
sp_helprolemember
sp_helprotect
sp_helpserver
sp_helpsort
sp_helpsrvrole
sp_helpsrvrolemember
sp_helpstats
sp_help_targetserver
sp_help_targetservergroup
sp_helptask
sp_helptext
sp_helptrigger
sp_helpuser
sp_indexes
sp_indexoption
sp_invalidate_textptr
sp_linkedservers
sp_lock
sp_makewebtask
sp_manage_jobs_by_login
sp_monitor
sp_MShasdbaccess
sp_msx_defect
sp_msx_enlist
sp_OACreate
sp_OADestroy
sp_OAGetErrorInfo
sp_OAGetProperty
sp_OAMethod
sp_OASetProperty
sp_OAStop
sp_password
sp_pkeys
sp_primarykeys
sp_post_msx_operation
sp_processmail
sp_procoption
sp_purgehistory
sp_purge_jobhistory
sp_reassigntask
sp_recompile
sp_refreshview
sp_releaseapplock
sp_remoteoption
sp_remove_job_from_targets
sp_remove_log_shipping_monitor
sp_rename
sp_renamedb
sp_resetstatus
sp_resolve_logins
sp_resync_targetserver
sp_revokedbaccess
sp_revokelogin
sp_runwebtask
sp_server_info
sp_serveroption
sp_setapprole
sp_setnetname
sp_settriggerorder
sp_spaceused
sp_special_columns
sp_sproc_columns
sp_srvrolepermission
sp_start_job
sp_statistics
sp_stop_job
sp_stored_procedures
sp_tableoption
sp_table_privileges
sp_table_privileges_ex
sp_tables
sp_tables_ex
sp_trace_create
sp_trace_generateevent
sp_trace_setevent
sp_trace_setfilter
sp_trace_setstatus
sp_unbindefault
sp_unbindrule
sp_update_alert
sp_update_category
sp_updateextendedproperty
sp_update_job
sp_update_jobschedule
sp_update_jobstep
sp_update_log_shipping_monitor_info
sp_update_log_shipping_plan
sp_update_log_shipping_plan_database
sp_update_notification
sp_update_operator
sp_updatestats
sp_update_targetservergroup
sp_updatetask
sp_validname
sp_validatelogins
sp_who
sp_xml_preparedocument
sp_xml_removedocument
Replication Stored Procedures
xp_cmdshell
xp_deletemail
xp_enumgroups
xp_findnextmsg
xp_grantlogin
xp_logevent
xp_loginconfig
xp_logininfo
xp_msver
xp_readmail
xp_revokelogin
xp_sendmail
xp_sprintf
xp_sqlagent_msx_account
xp_sqlagent_proxy_account
xp_sqlmaint
xp_sscanf
xp_startmail
xp_stopmail
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_MShasdbaccess

SQL Server 2000

Lists the name and owner of all the databases to which the user has access.

Syntax

sp_MShasdbaccess

Return Code Values

0 (success) or 1 (failure)

Permissions

Execute permission defaults to the public role.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.