July 2, 2002 at 5:53 pm
I've got a linked server set up on a SQL2K server that connects to a SQL7 server using SQL security. Attempts to insert into a table on the remote server using the four part syntax fail with the message that ansi nulls must be enabled for the connection. Is there a way to do that for a linked server, if so, where? If not, suggestions for work arounds?
Andy
July 3, 2002 at 2:53 am
Why not use SET ANSI_NULLS ON?
July 3, 2002 at 10:10 am
I had the user try it orignally and it didnt work. I'll try to test again to see.
Andy
July 4, 2002 at 4:53 am
Make sure SET ANSI_NULLS ON is in a separate batch.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply