Heterogeneous queries

(1) Share

Report

Posted on by Wajahat Ali

1,500

Hi Guys

I have created Encrypted Audit Trail Application I have company database ,ABC and created another database with name ABC_Audit. In ABC_Audit, I have audit table where records are save in encrypted form. In company database , I have created one procedure to fetch these records from Audit table and apply decrypt key. This procedure is called from View (View doesn't support decrypt key that's why procedure is created and called from View). Both databases are in same SQL Server or Instance. No linked server is involved. SQL version is 2012 and GP version is 2015.

Now I am creating smartlist and getting this error. Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection.

I have set options at database level but no luck. View is not supporting this option to be set. In stored procedure, these options are already set. Any idea , how can this issue be overcome.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: Heterogeneous queries

Replace view with sql table, insert /delete data in your table from view and use it in your stored procedure.