I have a strange error when i run a sql proc using isql.exe.
I have tested the proc and it executes without issues when i run it using sql analyser, so i know it has something to do with isql
This is the execute statement
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>isql.exe -Udata_loads -Pdata
_loads -Segi15dstxsql02d -dmerHoldingStg -q"exec dbo.usp_Update_Holdings_Xref 'P
ORTIA'"
and this is the error message
Msg 7405, Level 16, State 1, Server EGI15DSTXSQL02D, Procedure usp_Update_Holdin
gs_Xref, Line 89
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.
I get the same error message even after setting the ANSI_NULL and ANSI_WARNINGS ON
Appreciate any help
maltu
I have tested the proc and it executes without issues when i run it using sql analyser, so i know it has something to do with isql
This is the execute statement
C:\Program Files\Microsoft SQL Server\80\Tools\Binn>isql.exe -Udata_loads -Pdata
_loads -Segi15dstxsql02d -dmerHoldingStg -q"exec dbo.usp_Update_Holdings_Xref 'P
ORTIA'"
and this is the error message
Msg 7405, Level 16, State 1, Server EGI15DSTXSQL02D, Procedure usp_Update_Holdin
gs_Xref, Line 89
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.
I get the same error message even after setting the ANSI_NULL and ANSI_WARNINGS ON
Appreciate any help
maltu
