Table Spacegreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Help me in shrinking table space. How can i shrink the tablespace of a particular Table.As we can use the truncate command in oracle to shrink a particular table space.Is the any command that i can shrink the table space. My database is around 12GB with log file. It is impossible to maintain it now. Please give me solution that i can shrink my tablespace.
Waiting for your reply
-- Anonymous, May 05, 2004
In Enterprise Manager, right-click the database to shrink, point to All Tasks, and then click Shrink Database.
Hope this helps,
-- Anonymous, May 21, 2004