Table Space : LUSENET : SQL Server Database Administration : One Thread

Dear Sir,

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


MOnojit Das

-- 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

Moderation questions? read the FAQ