KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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
Tags (comma-separated)
Save Edits
Cancel