Query runs on Query Analizer but not trough php code

[Bennett]

Greetings, I have a strange problem, that is that my query would run good on analyzer but id returns warning through PHP, here is the script:

 

IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='cart082010') UPDATE a SET 
a.c_empresa=b.c_empresa,.........
from cart082010 a, Sogfih_TOC.Sogfih_OPDF.dbo.cart082010 b  
WHERE a.c_empresa = b.c_empresa AND ..........
ELSE SELECT * into cart082010 FROM  Sogfih_TOC.Sogfih_OPDF.dbo.cart082010

 

 

please help....

[Bennett]

here are the general setting I use:

mssql_query('set nocount off

set arithabort on

set concat_null_yields_null on

set ansi_nulls on

set cursor_close_on_commit off

set ansi_null_dflt_on on

set implicit_transactions off

set ansi_padding on

set ansi_warnings on

set quoted_identifier on

set parseonly off

');

 

[Bennett]

forgot some details, running SQL Server 2000 and XAMPP 1.7.3 both on Windows server 2003