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
Pingback: Help! i want to migrate to MS SQL 2008?