I imported a bunch of tables from an old SQL server (2000) to my 2008 database. All the imported tables are prefixed with my username, for example, Jonathan.MovieData. In the table properties, it lists Jonathan as the DB schema. When I write stored procedures I now have to include Jonathan. in front of all the table names which is confusing.
How do I change all my tables to be dbo instead of Jonathan?
Current result: jonathan.MovieData
Desired result: dbo.MovieData