Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 HOW TO SET ANSI_NULLS ON

Author  Topic 

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2010-07-21 : 02:37:27
I have around 200 sp which is written in older version of sql server
now i want to move to 2005/2008

i am facing the problem of SET ANSI_NULLS OFF.

how can i set all the stored procedure at one go.
or is there any setting by which it will override the setting done in the sps.

Appreciate your quick reply.

Lets unLearn
   

- Advertisement -