0

I have created a database project (VS2012) from an existing sql server database (Sql 2012) which in turn uses Oracle linked server. Some of the Store Procedures in that database uses this linked server '[SMAC]..[SMACADMINISTRATOR].[BOND]'. When I build the database project, it gives lot of warnings as 'The procedure xxxxx has an unresolved reference to object.

How can I suppress these warning messages?

Improve this question

1 Answer 1

Reset to default
1

Open the Project Properties dialog and type in the SQL warnings to suppress (it's in the Build section, named "Suppress Transact-SQL warnings").

There is also a References Section in the Solution Explorer in the Project, perhaps you can add a reference there? Although perhaps not practial if there are many Procedures being referenced.. then it could be better to suppress all warnings of the given type.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Thanks..I have suppressed the warning as you told, It worked for me. One more thing, Can we create .dacpac for Oracle database using Visual Studio
I would say not no, not out of the box, afaik. Here is some info on Oracle and Visual Studio: oracle.com/technetwork/developer-tools/visual-studio/overview/…

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.