I am afraid these are not answers to my questions as 1) space was not released to system and 2 ) initial db size was pretty small. Thanks

sp_changedbowner

Changes the owner of the current database.

Detach- Move mdf and ldf files- Attach

Sorry, but all initial database info is in my 1-st message. Thanks

Shame on me- I forgot, thanks. After I updated usage I've got: unused=61G (and extra 20G were added to unallocated space). But my question still remains- why not all unused...

Thanks a lot guys for your help. I used dynamic sql to do the trick (not too elegant but it works).

Ryan: contributors number can be different. David: source12 (etc)- value,...

Thanks. Actually I've  already done this way

Thanks, guys. I'll definately delete foreign key from tblBig. Regarding others Ian questions:eventually I need to delete from tblBig 15 million rows (from 20)and from 3 related tables. TblSmall is...

Thank you, Yelena. This is what I am looking for.

BOL for Sql Server 2005: "How to: Configure the Database Engine to Listen on Multiple TCP Ports"

Thanks, Francis. I'll try it- hope this is working for Sql Server 2005 also

Thanks you, guys

Sorry for my previous message- I didn't get you. You mean that there is no way to connect to Sql Server 2K5 from 2K? Thanks

Yes, I know. But could you, please, be a bit specific- what to use? Thanks

Probably this will work for you. First, for existing mdf file uncheck check box "Automatically grow file' (i.e. to prohibit it's growing). Then create, let say, 2 extra ndf files....