Steve,

Have you tried to insert your result set directly into the ServerB
table
using a fully qualified table name insert, for example,

INSERT serverb.targetdb.dbo.servrbtbl(servername, drive, [freespace])
SELECT atatServerName AS ServerName, Drive, [FreeSpace]
FROM lbstblDriveSpaceTemp

Link ServerA and ServerB and the above should work.

The Hard Working SniperBot is trapping my response, so I've not
included the question to see if I can sneak this in, also removed the
"at" and "lbs" signs.

S. Davey (8/31)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


MS Sql Server LazyDBA home page