April 19, 2011 at 5:48 pm
I need to show what extended procedures are disabled and enabled.
For example...
xp_available media
xp_cmdshell
xp_dirtree
xp_dsninfo
xp_enumdsn
xp_enumerrorlogs
xp_enumgroups
xp_eventlog
xp_fixeddrives
xp_getfiledetails
xp_getnetname
xp_logevent
xp_loginconfig
xp_msver
xp_readerrorlog
xp_servicecontrol
xp_sprintf
xp_sscanf
xp_subdirs
April 19, 2011 at 6:42 pm
just xp_cmdshell is a configurable option of those xp's listed.
These xp's listed do not exist in sql 2008, those were sql 7 (maybe 2000 too)
xp_dsninfo
xp_enumdsn
xp_getfiledetails
xp_eventlog
The others are not configurable options (in the same way as xp_cmdshell), and are enabled by default.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2011 at 6:54 pm
Ok. Do you know of a way to return the status/setting of the xp_%?
I need to be able to show what they are.
April 19, 2011 at 7:11 pm
SELECT * FROM sys.configurations
ORDER BY name ;
GO
The only one you will see though is xp_cmdshell - because the others do not have a setting that is configurable on or off.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 21, 2011 at 2:41 pm
I understand about xp_cmdshell.
I guess the next question is to satisfy an audit, is there a way to find out what XP_ are used for what GUI tasks. Like a mapping document. I have to drop the ones that we don't need.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply