April 23, 2018 at 1:17 pm
There are better ways.
This article will work, probably much better than xp_fixeddrives and linked servers
http://www.sqlservercentral.com/articles/Drive+space/134523/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 24, 2018 at 4:14 am
Hm... not the simplest solution, and surely overkill for what I need, but the idea of collecting xp_fixeddrives data in some table looks feasible, I'll try that.
April 24, 2018 at 5:04 am
While trying to implement the 'collect, then select' solution, I found out, that the procedure I mentioned in my post:
CREATE PROCEDURE [dbo].[uxp_fixeddrives]
WITH EXECUTE AS OWNER
AS
BEGIN
SET NOCOUNT ON;
exec sys.xp_fixeddrives
END
works just fine from msdb (but not from master, where I put it earlier)
So, the problem is solved
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply