New to 2005. Restored a db from 2000. No problems. Want to copy tables from it to a new db on the same box (also in 2005). Go into the import / export wizard. There is a drop down labeled 'database' in the second step. All it shows are system databases (master, model, msdb,...) but not the ones I created or restored. Windows authentication. I could see those databases in 2000 no problem. What am i missing?
Thanks Ray