shresthaal
Programmer
DECLARE @LogicalFileName SYSNAME,
@MaxSize INT,
@OriginalSize INT,
@StringData VARCHAR(500)
SELECT TOP 1
@LogicalFileName = RTRIM( [name] ), @MaxSize = CASE [maxsize]
WHEN -1 THEN -1
ELSE ([maxsize] * 8)/1024
END
FROM sysfiles
WHERE [groupid] = 0
ORDER BY [size] DESC;
print @LogicalFileName
I have this code I thought this would work am I missing something?
@MaxSize INT,
@OriginalSize INT,
@StringData VARCHAR(500)
SELECT TOP 1
@LogicalFileName = RTRIM( [name] ), @MaxSize = CASE [maxsize]
WHEN -1 THEN -1
ELSE ([maxsize] * 8)/1024
END
FROM sysfiles
WHERE [groupid] = 0
ORDER BY [size] DESC;
print @LogicalFileName
I have this code I thought this would work am I missing something?