This would get you basically all that --
select 'SQL instance = ' + quotename(cast( SERVERPROPERTY( 'servername') as varchar(25)))+' , '+cast(SERVERPR OPERTY('product version') as varchar(10))+', '
+ cast(SERVERPROP ERTY ('productlevel' ) as varchar(10))
+ case when SERVERPROPERTY ('IsClustered') = 1 then ' (clustered)' else '' end
+ case when SERVERPROPERTY ('IsFulltextEna bled') = 1 then ' ,Fulltext enabled' else ''...
User Profile
Collapse
-
copper21 replied to SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)in SQL ServerTo see exact space used in the current database (sp_spaceused is not always accurate unless dbcc updateusage is run), you could use this :
select cast(size/128.0 as decimal(10,1)) as [size mb], cast(FILEPROPER TY(f.name, 'spaceused')/128.0 as decimal(10,1)) as [used mb], maxsize [maxsize mb]
, cast(growth*8/1024 as varchar(11))+ca se when f.status&0x1000 00>0 then '%' else '' end [growth]
, isnull(filegrou p_name(f.groupi d),'log')...Leave a comment:
-
copper21 replied to SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)in SQL ServerI'd recommend dbcc shrinkfile in 500mb chunks, to run more efficientlyLeave a comment:
No activity results to display
Show More
Leave a comment: