actually i am looking in to a old bak file from tape and more over all our backup files are saved as .bak files.

Thanks for that.

is there any risk involved granting that permission to a user?

I am not sure what you are saying but i have a simple question about standard reports.

What permissions need by a user to view standard reports not custom reports.

what permissions a user should have to view all of the reorts under Mangement Studio in SQL 2005.

Actually.. I am sorry, i do have indexes.

I am changing INT data type to BIT, does it not save any sapce to me ?

I am not looking for any 3rd party tool and i dont have any intention to buy, just want to do this using existing sql tools as this is only...

so far i didnt get any explanation for why space is not reclaimed when column are deleted even after shrinking.

technically when data is deleted and then shrinked i have to...

all tables which are in question pretty much increased in space

version :

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft...

I dont think reindexing helped me because reindex will rebuild all indexes and my database grown instead of reclaiming space back.

Only 1 solution i see getting my space back after...

are you asking me to run dbcc dbreindex on the database where deleted few columns and check if i got my space back.

when i export the table to a new table the space is reduce by 30%. Actually i want to know the reason why space is not claimed back when columns...

I dont have any indexes on any tables in that database.

Can you some one give correct explanation as to why space is not released when some column are deleted?

Here is another interesting thing... I did an export of the whole database into a new test database and the size seems to went down to 142MB

Can some one explain...

surprisingly after deelteing the column in a table the space used is increasing instead of decreasing though shrinked the databse hoping that it would release space used by the column...

as it is a very big database i have to shrink them to get my space back and more over once moved to production server every one just read the...