Shrink SQL Server 2000 Database

Written by

Jugal Shah

in

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

Comments

One response to “Shrink SQL Server 2000 Database”

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

    […] Shrink SQL Server 2000 Database « Database Solutions (MSSQL and MySQL) […]

    Reply

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

More posts