Viewing 15 posts - 9,511 through 9,525 (of 18,926 total)
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...
August 10, 2007 at 10:43 am
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...
August 10, 2007 at 10:13 am
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...
August 10, 2007 at 10:04 am
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...
August 10, 2007 at 9:57 am
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...
August 10, 2007 at 9:49 am
That's exactly why it's so fun to have 450+ K members. Thanks Carl for the assist.
August 10, 2007 at 9:41 am
That line was missing :
cmd.CommandType = Data.CommandType.StoredProcedure
August 10, 2007 at 8:21 am
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. ...
August 10, 2007 at 8:20 am
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...
August 10, 2007 at 4:55 am
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,...
August 9, 2007 at 8:45 pm
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...
August 9, 2007 at 5:14 pm
Viewing 15 posts - 9,511 through 9,525 (of 18,926 total)