var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How can I compact MS SQL 2000 Database?
Now my database is contain a big size and still grow up. I think may I can compact it to small size like ms-access.
How can I compact MS SQL 2000 Database?
you can shrink the database
You can shrink the databse by any of the following option.
1.You can use the syntax dbcc shrinkdb <databasename> on query analyzer
2.selse sqlserver -> enterprise manager ->select the database -> right clik this and select the option shink
for more information u can use books online shrink database option
To prevent the database from unwanted growth, you can set the 'Auto shrink' option (in Enterprise Manager, right click on your database, choose properties, select options tag and check the auto shrink option).