Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RyanAustin
Yak Posting Veteran
50 Posts |
 Posted - 2008-03-19 : 14:54:59
|
| 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. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-19 : 15:08:44
|
| [code]select * from openquery (test_server,'set fmtonly off; exec master..xp_fixeddrives')[/code]CODO ERGO SUM |
 |
|
|
RyanAustin
Yak Posting Veteran
50 Posts |
Posted - 2008-03-19 : 15:11:45
|
| Perfect thank you!! |
|
|
|
|
|
|
xp_fixeddrives