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.
hi,
xp_fixeddrives return 2 set of records. How do i store this result into a table?
Thanks
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.
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
hi,
sp_spaceused return 2 set of results. How do i store this result into a table?
Thanks
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
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