This help?

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31202/

Is this a char field? Can you use Substring to build something up?

I've got some land I can sell you as well.

Caveat Emptor

dgreatho, great points about us not knowing what to do. I think that's a problem, and don't know where we can go with that. Who should decide? Business wants to...

What do you mean by history? What information are you looking for? If it's code history, you should be using a version control system, and I know SQLCompare can compare...

First you should use @@scope_identity for the value.

A trigger will get this if you need it always done. If not, moving to GUIDs allows you to generate things in advance.

Are they not separate steps in the job?

:), the Prius update is next month. Alternate energy and cars each month. 520miles on the last tank, trying to beat that with this one, around 52mpg with my son...

Good comments and it's definitely a balance. I've heard issues about our grid, which I do think are legitimate. The idea of storing power in a movable form, perhaps fuel...

Being stupid can help: http://www.darwinawards.com/

:), passed along.

OK, the author (me), can't type. 😛

Fixed

banwidth, row size, no way to know.

Send 1000 records as a test. Extrapolate.

This isn't really the place for this, and we don't want .SQLs up there for safety.

Adam, really you should submit this as a script, and there are comment sections for...

Microsoft licenses and checks sockets, not cores. SQL will use all 8 cores, you'll need 2CPU licenses if you go that way.