Xp_availablemedia
Dec 26, 2001
Hi!
I'm trying to create a plan using the maintenance plan wizard. Whenever I click the ellipses button after selecting "Use this directory" (in the Specify Backup Disk Directory screen), the enterprise manager hangs. After doing some investigation, it looks like EM calls the extended sproc "xp_availablemedia". When I try to run this manually, it hangs also. Anyone have any idea what this xp does and where I can find some documentation on it?
I'm using SQL 2000 SP1
Thanks!
View 1 Replies
May 2, 2007
Without systemAdmin role, xp_AvailableMedia can still run (after granting execute permission) but just return 0 rows.
It seems we have to give the user SystemAdmin role, in order to get the list of devices in SQL 2005, while in previous versions of SQL Server, the user granted the execute permission for xp_AvailableMedia will be able to get the list of devices.
Is this be design? Is there any way the a NON-SA user can retrieve device list? If yes, what extra permissions do we have grant?
Thanks in advance for your help.
Frank
View 3 Replies
View Related
