I'm learning to use sql2005 and working with the import wizard. I have a new database and all tables are created with a schema called ex: MYSCHEMA. The schema is not DBO
I am in the wizard and get to the part where I select 'copy one or more tables' . When I chose this, I have hundreds of tables to import and the wizard is showing all the DESTINATION tables with the schema DBO not MYSCHEMA. Now if click on the drop down window in the destination box, I can select the table with MYSCHEMA.
What I want to know is do I have to hand select the correct table for all 360 tables? Is there a place where I can specify that I want all the tables with MYSCHEMA as the schema? :w00t: