Urgent help needed with linked servers
-
Hi!
I have two servers on two different computers in two different domains.
On ServerA there is two Databases I need to use and on ServerB there is one.
On both servers I have done exactly the same:
sp_addlinkedserver 'X',N'SQL Server' Where X is the name of the server
sp_addlinkedsrvlogin 'X','false',NULL,'Username','Password'
The user has db_owner on all databases I need to use.
From ServerA I'm able to get information from serverB when running a stored proc.
The problem is in a trigger on the database in ServerB.
This trigger does a select on ServerA "select * from ServerA.DB.dbo.Config".
When this trigger is executed I'm getting error 7405
"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."
These options is set on both servers and the options is set before creating the trigger.
Does anybody have any ideas?
Thankful for any help!
-
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=139297
A.J.
DBA with an attitude -
Make sure you read the entry from olavho in the above link.
A.J.
DBA with an attitude -
Thanks!
I'll try this and see if it works!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply