SET ANSI_DEFAULTS ON in Report Script

[dolodolo]

Hi,

How can I set ANSI_DEFAULTs to ON in a report script in SQL Server. Here is the select statement:

SELECT
t.sfirstname,
t.slastname,
ts.status,
pm.susercode,
pm.susertype,
pr.scode

FROM pmuserex pm
INNER JOIN [jqnnbla_sandbox_2k5].jqnnbla_sandbox_2k5.dbo.tenant t on t.hmyperson = pm.hobjpointer
LEFT OUTER JOIN [jqnnbla_sandbox_2k5].jqnnbla_sandbox_2k5.dbo.property pr on pm.hproperty = pr.hmy
LEFT OUTER JOIN [jqnnbla_sandbox_2k5].jqnnbla_sandbox_2k5.dbo.tenstatus ts on ts.istatus = t.istatus

Thanks,