View My Drafts
Good point Jonathan. I did go back through all remaining tables and reset columns like that myself, but starting from an empty database is certainly another way to go!
Joe Miller | Director of Systems Architecture HCS | 2510 S Church St, Paris, Texas 75460 | www.hwh1887.comToll: 1.800.442.TEAM | P: 860.839.6970 | M: 860.839.6970 | F: 903.784.1471 | email@example.com
Confidentiality Note: This e-mail message and all attachments are intended solely for the use of the addressee and may contain privileged and confidential information.Any unauthorized review, distribution, copying, or other use of this message or its attachments is strictly prohibited.If you have received this message in error, please notify the sender immediately by replying to this message and delete it from your computer.
Way back when I had to do the same thing on a regular basis, I did something like this to get the list of tables I needed to be concerned with, including any 3rd party or custom tables.
Then just figure out which master record or setup tables have company/sub specific info and make sure that also gets changed.
SELECT T.name TableName,i.Rows NumberOfRows FROM sys.tables T JOIN sys.sysindexes I ON T.OBJECT_ID = I.ID WHERE indid IN (0,1) ORDER BY i.Rows DESC,T.name