Shrink SQL Server 2000 Database

1 Reply

Query to generate DBCC shrinkfile script for all the user databases in SQL Server 2000


select 'use ' + ltrim(rtrim(db_name(sd.dbid))) + char(13) + 'dbcc shrinkfile (' + quotename(ltrim(rtrim(sf.name)),'''') + ' ,truncateonly)' from sysaltfiles sf
inner join sysdatabases sd on sf.dbid = sd.dbid
where sd.dbid > 4

1 thought on “Shrink SQL Server 2000 Database”

  1. Pingback: Help! i want to migrate to MS SQL 2008?

Thanks for the comment, will get back to you soon... Jugal Shah