padmakumark26 (12/8/2016)

---

We are combining two db into one .Now both have default schema as dbo.

In the New combined DB we will have two user(Hms,EAM) and two schema (HMS,EAM) and login (euser,Huser)

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

SELECT * FROM vw_EmployeesStuff

And not have to query like:

SELECT * FROM HMS.vw_EmployeesStuff

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