I can't wait to see what others have to see about this. Right now I'm drawing blanks on this one.

At least you got things straightened out to a point where...

Good advice Mark.

I was following the I need it yesterday comment so I put in the quickest of all solutions to type in and execute... but if the db is...

My first comment is why the heck would you want to do that (add a column in a specific space in the table)? 

But here's the answer to your problem...

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.