Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics
ansi-nulls, heterogeneous, sql-server
Solution
Added this BEFORE your statement rather than at the start of the main query
$result = mssql_query("SET ANSI_NULLS ON;");
$result = mssql_query("SET ANSI_WARNINGS ON;");
Problem
I have checked over the whole web and couldn't find a solution that seems to work for me.. I have recreated my stored procedure, making sure to have these lines as first lines: ``` SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_WARNINGS ON GO CREATE PROCEDURE test_insert AS .... BEGIN ... END ``` I only get this error when i call my stored procedure from php. it works fine in sql server.. i really don't know what else i can do..please help me ;_;