Linked Servers and CUIC

[pdelk]

Like several other posts here, we are having an issue with ANSI_WARNINGS and ANSI_NULLS when trying to create a report definition against a linked server in CUIC 10.x.

I understand from previous posts, that we need to have these set on the connection, but to do that, I need to change the server option on the AWDB and the external server.  Is this correct and is it supported?

[ewindgat]

If I understand, you can set these option in your SQL.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

[pdelk]

That is not working. It still says we have to set it in connection properties, which we can do, but just wondering if it is supported to change a server-wide setting

- Paige Delk

Sent from my iPhone

(please excuse typos)

[ewindgat · Accepted solution]

You are correct, its in the connection properties.