CODEWITHSUNDEEP
sql-serverschema
Limey
Limey

Reputation: 2772

View needs Schema Reference

I have a Dev database that was cloned from a prod DB and was working just fine. Suddenly, all view references in my SQL fail in my app because they need the schema reference to find the view. I have checked both the view and the login (on the server and DB levels) and they all point to rw as the default schema. Does anybody have any idea of what else might be causing this problem?

Thanks

Upvotes: 0

Views: 119

Answers (1)

Anon246
Anon246

Reputation: 1841

As seen in the comments... Is it possible that the account is an "sa" in the dev server? That will cause the login to behave differently than in an environment that has less elevated rights. Specifically, it may come in through the dbo schema as the default schema, which would cause the above error.

Upvotes: 2

Related Questions