Access permission to XP_FIXEDDRIVES

• aloysiuspaul

  SSC Veteran

  Points: 235

  More actions

  March 25, 2009 at 12:03 am

  #136034

  Hi ,

  We have developed a monitoring tool and we need to get the disk space in each server.We need to execute XP_FIXEDDRIVES procedure.

  but the user needs a sysadmin role to execute this procedure.But we cant give this privelege for the user .

  Is there any alternate solution to execute the procedure.

  Regards,

  Paul

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 25, 2009 at 8:03 pm

  #966396

  Try running it uder account having sysadmin privilege. Read about Execute As at http://msdn.microsoft.com/en-us/library/ms188354(SQL.90).aspx.

  MJ