Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are migrating from a SQL Server 2008 instance on a shared host to our own box. Our issue is we have a bunch of tables, procs and views that are prefaced with a schema (let's call the schema 'me') other than dbo.



We're having issues now that we have restored the backups from the shared host to our new box. When logged in as 'me', we need the queries to run like this:

SELECT * FROM vw_EmployeesStuff

And not have to query like:

SELECT * FROM **me.**vw_EmployeesStuff

We've tried to change the default schema for the user from dbo to me, but it doesn't seem to be 'taking'. Any thoughts or help is much appreciated. TIA

share|improve this question
Well, unchecking sysadmin seemed to fix this immediate issue, but caused a new one. Now the 'me' user cannot expand any server nodes in SSMS – Jeff Borden Apr 18 '13 at 6:18
It looks like ultimately some of our logins were orphaned because we created the databases from backups from a different server. – Jeff Borden Apr 18 '13 at 22:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.