> Don wrote: > With regard to 1,498 tables, do you mean, User Tables? just for clarity.
Yes, 1498 user tables. The application was originally built on a flat-file database system like DB3/4 or Foxpro and was ported to SQL Server without re-engineering the database. All of the tables have 8 character names and the column names are a max of 8 characters as well. The tables are not named intuitively, such as UPR00100 = Employee Main table, UPR00101 = Employee addresses... and so on. Trouble is that I don't know how often these tables are touched. I do know that the process of printing a check involves at least 20 tables. The application is a complete accounting package that has been modified to include benefit, deduction and tax compliance functionality. According to the Sysobjects view there are also 20,644 stored procedures and 166 views. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
