List of Enabled System stored procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

List of Enabled System stored procedures

Author

Topic

boyeneye
Starting Member

3 Posts

Posted - 2011-01-26 : 11:45:00

Hi All,

Please how can someone determine the list of enabled stored procedures on SQL 2008

thaning you in advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-26 : 11:47:45

what do you mean by enabled? you mean ones that are enabled by admin for you?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-26 : 12:10:35

Stored procedures can't be enabled or disabled, so I'm not sure what you're looking for. Details please?

--
Gail Shaw
SQL Server MVP

boyeneye
Starting Member

3 Posts

Posted - 2011-01-26 : 12:34:59

i want to know if the following system stored procedures xp_sendmail, xp_dropwebtask, xp_runwebtask etc. are enable on my SQL 2008 database

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources