-
Help with script
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|