CREATE TABLE #FreeSpace
(
Drive char(1),
MB_Free int
)

INSERT INTO #FreeSpace EXEC master..xp_fixeddrives

CREATE TABLE FreeSpaceData
(
interval datetime not null,
Drive char(1),
MB_Free int
)

INSERT into FreespaceData values (getdate())
INSERT into FreespaceData select * from #freespace

I am trying to insert a row of date, drive and diskspace into FREESPACEDATA table but there's a syntax error.

Any ideas ho w to get around this?