Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  Extra tables being present after Migration

Author  Topic  teja765 Starting Member 1 Post Posted - 2011-02-16 : 05:00:48 I have a database with 65 tables in MSAccess. I used the SSMA for Access tool to migrate it to SQL Server 2005. The migration has 4 steps: a. SSMA Access converts database objects. b. Load objects into the SQL database. c. Migrate the data. d. Link SQL tables to the Access application. In the first step itself, it is showing those extra tables namely: 1. ~TMPCLP491441 2. ~TMPCLP531441 Though these tables are not present, the table is a replica of one of the tables out of the 65 without data. I just wanted to know the reason as to why the tool is including them. 1. An expression of non-boolean type specified in a context where a condition is expected, near 'Or'. 2. The isnull function requires 2 argument(s). As these two errors are not pointing to any of the tables, i am not able to know what they mean. Kindly reply ASAP.