Good, short, sweet coverage of OpenDataSource and some of the key advantages to using it and when to use it... Nicely done!

karthikeyan (12/12/2007)

---

1) How many types are there like 'P' ?

2) I did search in Google,but i didn't get clear information about the table.So can you explain me where we need...

Heh... Like what? There's no magic fix, no instant answers to such problems and all of the fixes take...

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 🙂