Ihave two servers , One production and one test.
the test server is linked to the production server.
In the test server I have created one database named space and it has a table named spaceofprod with columns drive and MB_free.
now when I run exec master.sys.xp_fixeddrives on production server it gives me result set in two columns.
I want to insert the output of this above mentioned query which was run on production server in the table created on test server named spaceofprod as mentioned earlier.
please give me the query.
Regards, Tejas Patil
View Complete Post