I'm no expert on how the server organize the data.  However I'd expect the server to be bright enough to reuse the available space (please correct me if I'm wrong...

Repeatedly run this statement untill you get no errors :

EXEC SP_msforeachtable 'DELETE ?'

The errors will come from FK constraints (and maybe some triggers).

Each run will drop one level of...

That's exactly why it's so fun to have 450+ K members.  Thanks Carl for the assist.

That line was missing :

cmd.CommandType = Data.CommandType.StoredProcedure

I think the question is in regard of wether the actual column of data is physical data... so that is obviously a yes.  As for the index you are right. ...

The data in both tables is physical, the link between them is an object is SysObjects that makes sure that all the data in both table is valid (as long...

This works in 2000, no idea for 2k5.

IF OBJECT_ID('tempdb..#su') > 0

 DROP TABLE #su

GO

CREATE TABLE #SU (Name varchar(128), Rows varchar(25), Reserved varchar(25), data varchar(25), index_size varchar(25), unused varchar(25))

INSERT INTO #SU (Name,...

Is this a pivot query where each rows becomes a new column?  If that's the case, then you may be able to write a vbs script to pivot it for...

Paypal does that too .

There's always paypal .

http://www.microsoft.com/downloads/details.aspx?familyid=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&displaylang=en

Yes, that's what I use here at home.

Yes eval installs on XP.

I don't know if it's common practice to have a carved in stone design before doing dev work.  I'd surely be ok with having a solid design plan, but which...

Maybe this can help too.

http://software.pricegrabber.com/database-management/m/436437/search=sql%202000

Have you checked out the MS site to see if you could buy / download one version of it?