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
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
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
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
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
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
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