How do I reference an object in another schema MS2005

There is a console application written that we cannot change the source code for.  It is a very simple application.  Somewhere in the application it has a stament along the lines of

SELECT FieldABC FROM Carriers

This is referencing a database from a vendor application.  During a recent upgrade, the Carriers table became part of the 'PM' schema and now needs to be referenced as PM.Carriers.

Is there a way I can set it up so that the statement above will work.  Right now it is failing with an error saying Carriers does not exist.  I explicitly granted the SQL login the console application uses SELECT permission on the table - but it still did not work.  

Any help is appreciated.
LVL 2
jport88Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrandonGalderisiCommented:
You can create a view called Carriers in the default schema that selects each column from the pm.carriers table.  

You can then place a(n) instead of insert/update/delete trigger(s) on the view if the console application needs to perform those actions.
create view SCHEMANAME.carriers
as
select fieldabc from PM.carriers

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.