Oh.... that's why the turnover rate is so high

Perfect... thank you for the feedback!

Somebody's not listening, Brian.  WHAT does the EXE do?  The reason I ask is because you may not need the darned thing at all.

Halifaxdal...

I just noticed that the size of the MDF table doubled when you added the column... you've done something wrong... very wrong... stop modifying the original table!!!

Heh... point well taken, David... we have a day or two just like that.  Our "big one" is affectionately known as "Cycle 28".

Sorry Andreas... That's absolutely incorrect and you really need to check your facts before making such an unqualified statement... Try this... insert a column in the middle of an existing...

You are partially correct... all of the SQL objects will be constructed from what is in the MODEL... However, the listing from sysfiles shows the following file names for the...

Heh... I missed THAT!  Not only does the table need some fixin', but you do need to add some memory!  My desktop box has a gig... a server running standard...

Cory,

Great idea but, the Model DB files don't show where new files would be made (as a default)... they only show where the current Model files are.

For the other DB's, then sysfiles...

KBrown,

You all set?  Michael's solution seems to do what you asked but just making sure (pretty cool sequence generation function he's got there, huh?) because of the duplication of stock...

You DO need to access the registry... You can either do it from the front end or you can read them using the unsupported xp_RegRead stored procedure.  For SQL Server...

Yardstick?  Is that anything like the 2x4 I normally use?

Oh yeah... almost forgot... you need a complete list and script for any triggers that may exist on the table as well as a complete list of views that use...

Ok, I can tell you're just a little nervous about this whole thing and I don't blame you one little bit... so, here's the plan and why I asked the...

Nope... I've seen this before... I call it "chain" join.   If we look at Wade's join "chain"...

FROM Inventory AS I

JOIN Block AS B

JOIN Phase AS P

JOIN ProjectSub AS PS

JOIN...