Heh... I say, stop messing with it. Sample the size of the used portion for a month, use that determine the growth rate for 12 months, set it to...

I just copy directly from prod to archive... no staging. I do it in small enough chunks where I don't need a cursor to prevent blocking.

If you really want to lock things down, use BULK INSERT and format files (if you need them). Take a peek in Books Online.

Run DBCC UPDATEUSAGE and see if that get's rid of the negative numbers.

Worked for me.

Heh... it's the twiching eye that really gets to them. 😉

BWAAA-HAAAA-HAAA! OMG!!! ... If you think the posted questions are getting worse, you aint seen nothin' compared to real life... here's some code I just found in one of...

If the [Field Length] isn't character based (and, it shouldn't be), you'll probably have to add an explicit conversion to [Field Length]... but it is the classic way to do...

Absolutely agree... but it won't change their mind...

30 seconds for only 4K records? Take a look at the following...

http://www.sqlservercentral.com/articles/Test+Data/61572/

mm... I'm confused... you say the time format is "tttt", but you have six characters for the time in both examples and one of the sets of 6 looks like......

Or, you could do a cross-tab...

http://www.sqlservercentral.com/articles/T-SQL/63681/

Dan Epps (12/7/2008)

Not without tons of mods the the forum software. We're only talking about a half-million or...

Same here... thanks for the feedback. Sorry I got side tracked...

No apology necessary... I'm not the one that just put a cursor into production.