Xp_fixeddrives

Mar 19, 2008

I have a monitoring site setup that looks at different aspects of the database and the health, and the latest addition is checking drive space.

I know you can use master..xp_fixeddrives to return all the drives and space that is available. But when I run this through an OpenQuery it errors out:

"select * from openquery (test_server,'exec master..xp_fixeddrives')"

"Cannot process the object "exec master..xp_fixeddrives". The OLE DB provider "SQLNCLI" for linked server "test_server" indicates that either the object has no columns or the current user does not have permissions on that object."

Any suggestions??

Thanks.

View 2 Replies


ADVERTISEMENT

Xp_fixeddrives

Jan 15, 2007

Hi everybody,

Does anyone knows the alternative for xp_fixeddrives or what privilege should i grant to a normal user to execute xp_fixeddrives which returns the disc space details in sql server 2005.

Thanks in advance.

View 9 Replies View Related

Xp_fixeddrives

Apr 19, 2006

hi,

xp_fixeddrives return 2 set of records. How do i store this result into a table?

Thanks

View 6 Replies View Related

EXECUTE Master.dbo.xp_fixeddrives 2

Dec 13, 2002

Hi,

My production server is win2000 sql 2000 sp2.

Couple of days back when I tried to take the backup of the main database through EM (right click on database, all tasks--> backup database ), it hung at the point when I tried to select the drive for the device. However, I was able to take backup through scheduled task at that point.

Anyway, I still see the open connection (after two weeks) for that in the current activity window.
Here is the detail about the process.

'EXECUTE master.dbo.xp_fixeddrives 2'

I have read about it that it is a known sql bug since sql 7.0. But what is the solution to work around it? is it ok to kill this process? what are the possible consequences? Or how can I get rid of this SPID?

The next planned reboot for the server is 31st January. So rebooting server is not an option.

Thanks,
Shaili

View 1 Replies View Related

Sp_spaceused - Please Ignore The Xp_fixeddrives

Apr 19, 2006

hi,

sp_spaceused return 2 set of results. How do i store this result into a table?

Thanks

View 5 Replies View Related

Extended Stored Procedure Xp_fixeddrives

Mar 25, 2002

We are on Windows 2000, SQL Server 2000, and a SAN. Our data and backups are located on the Storage Area Network.

I am attempting to restore a database with a backup on the SAN through Enterprise Manager. I selected 'From Device', 'Selected Devices'. SQL appears to hang. After looking at Current Activity, I have identified that it is running 'EXECUTE master.dbo.xp_fixeddrives 2'.

Are there any known problems with SQL Server 2000 and SAN? Has anyone encountered this error?

Thanks
Kim

View 3 Replies View Related

Xp_fixeddrives With Limited Rights No Results!?

Apr 17, 2007

Hi

Does anyone here know why xp_fixeddrives with a limited user returns an empty result set on 2005?

In essence I want to create a report which shows disk space remaining, an upgrade of an old one. It works fine on 2000, but seems to need sysadmin rights on 2k5. I would appreciate it if someone can suggest how to get it working - or an alternative solution!

Cheers

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved