I would go ahead and use the Export/Import wizard at this point, like you were before. The problem before was that the Export/Import wizard was not creating the tables as...

If you only want to move a couple of tables and sps. I would take this approach.

1)Go into Enterprise Manager

2) Select Source Database

3) Right Click select All Tasks/Generate SQL...

How are you transfering them?

The easiest way to transfer a database is to detach the database, copy the datafiles to the new server, attach the database on the other end.

Ross

...

I agree I have not really understood why the schema concept is there. It has caused more problems for me that it has been useful. We have a research dept...

I got it to work! Just had to read more in BOL and do more figuring.

Thanks,

Ross

I still think a good reason to have WA is that it forces the person to have authenticated to our domain. Using SQL Logins someone could (in theory) execute lots...