JohnG (12/12/2007)

Jeff,

I did answered your specific question which was why would the length of...

Ok... I've gotta ask...

Seems to be the outsourcing capital of the world so what's wrong with staying in India?

No, no... the rant is understood and appreciated. When I first reported to my company, they had and average of 640 deadlocks a day with spikes to 4,000, no...

Cool... thanks for the feedback.

Heh... no... I want to know why you'd force any delay on processing... there's only one reason I can think of but I don't want to "lead" anyone on the...

Dropping the procs will be a very big deal if there are any dependencies... the script generator isn't real good a recognizing those 😉

Ack... don't drop them... then you have to worry about all sorts of things including grants, etc, etc.

Generate ALTER statements for them all.

Heh... output the table names and column names to a spreadsheet... have them fill out the spreadsheet. Use the spreadsheet as the source of data to insert the comments...

I don't understand why you need BCP for this... what's wrong with just doing a straight insert into the new tables?

Just a thought... what actually forces the user to enter a "#" sign before the number?

So... are you happy with that answer or is there something else?

That should do it 🙂

Heh... sorry... don't see the connection 😛

What do you do when the requirements change and the datatype...

Yuh huh... you watch... the next thing the boys from ops will ask for is a summary of the files sizes 😉