Hello Kundan,

One important factor when you try to decrease the size of a database is that deleting items from tables will normally not automatically decrease the filesize of the database file. Deleting items is only one step of the road, unfortunately. Second step is to perform a "shrink" of the database. You should be able find your way through Godaddy to find out how to shrink your database (I usually just do it via my SQL Management Studio via remote connection but that might not be possible with a shared hosting like GoDaddy).

Rgrdz

</P>

Thanks Peter.

I have restore the database on my local SQL Server  2005 . Can you please post the command to shrink the database after deleting the table records. I did the one suggested by Csmith but it does not freed much.

Any help will be apprecuiated

Thanks