set ansi_nulls true for database connection

• ddoria

  SSC-Addicted

  Points: 464

  More actions

  May 12, 2003 at 2:59 pm

  #101473

  error 7405 - set ansi_nulls true for database and still getting the error when trying to created stored procedure. Accessing outside SQL Server to Oracle. SQL works in Query Analyzer correctly. Just need to create the stored procedure.

• RD Francis

  SSCarpal Tunnel

  Points: 4867

  More actions

  May 13, 2003 at 1:43 pm

  #457031

  I think I had to do something like that earlier today, just for a SQL Server to SQL Server connection, not to Oracle. I added the following:

  SET ANSI_NULLS ON

  GO

  SET ANSI_WARNINGS ON

  GO

  above my stored proc code, and it worked fine. I actually added this through the proc code window in Enterprise Manager, I think.

  RD Francis

  
  R David Francis