Linked Server - Error

Hi all-

I created a another SQL Server as linked and I use them in some of my UDFs and SPs. Earlier these functions worked. But this morning, when I try to alter the definitions of these objects or query them, I get the following error message,
"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query."

Iadded SET ANSI_WARNINGS ON , but I still get this error. Any ideas?

- CBhttp://www.dbforums.com/t492719.html

http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch .asp%3FArticle%3D296769|||Thanks Snail. It worked.

- CB
Originally posted by snail
http://www.dbforums.com/t492719.html

http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fbin%2Fkbsearch .asp%3FArticle%3D296769