how to compact a database

[JazzMaan]

hi

i am new to sql server.

how can i compact a database, in access compacting the database removes all extra stuff from system tables etc

i have deleted records that are using identy fields, and i want to insert the values that have been taken by those identy values.

thanks

 

[gradley]

Lookup DBCC SHRINKFILE or DBCC SHRINKDB in BOL.

 

[JazzMaan]

thanks

but i was told by someone that shrink in my case dosent clear out the used identy values.

i droped and recreated the table .. and that worked

 

[SQLBill]

JazzMan,

You were told correct. The SHRINK commands only remove empty space from the database or log.

I don't think SQL Server has anything comparable to MS Access' compact database ability.

-SQLBill

Posting advice: FAQ481-4875