Post reply

Obtaining total disk space from linked servers

  • June 25, 2007 at 11:30 am

    #117538

    I have been modifying a query I stole from the internet (can't give proper credit since I can not locate the original source of the query).  One section of the query uses OLE Automation to obtain the total disk space for the local server.

    I have modified the query to use linked servers to provide all of it's information but have been unable to populate a total disk space column because the command sp_OACreate apparently will not work for a linked server.  The method it is using is 'GetDrive' and that works fine for the local server.

    Any suggestions for how I might obtain the total disk space for a linked server?

     

    Chuck Putney

  • June 25, 2007 at 1:55 pm

    #715011

    create an strored procedure on the remote server with your query in it

    Execute the remote procedure.


    * Noel

  • June 25, 2007 at 3:29 pm

    #715038

    Solved my problem.  

    Thanks,

    Chuck

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply