Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Mark Tierney Server Farm Reporting - Part 1 RE: Server Farm Reporting - Part 1
noeld
SSC Guru
Points: 96590
More actions
August 1, 2007 at 9:06 am
#723906
It *is* doable:
select a.* from
openquery(SERVERNAME,'SET FMTONLY OFF; EXEC(''dbcc sqlperf(logspace)'')') a
Just make sure that:
1.you have the necessary permissions
2.lazy schemavalidation = true
Cheers!
* Noel