|
Posted by balaji on 11/21/06 22:17
I have a database which contains more than 20000 stored procedures
which were created with
ansi nulls off. This i found out using the query
SELECT name,AnsiNullsOn FROM
(
SELECT name, OBJECTPROPERTY(id, 'ExecIsAnsiNullsOn') AS AnsiNullsOn
FROM sysobjects WHERE type = 'P' ) A WHERE AnsiNullsOn=0
Is there any way that i can set this property to 1 for all the stored
procedures i have??
I know the alternate method is to drop the procedure and execute the
scripts again with AnsiNullsOn = 1.
Is there any other simple ways?? It will be very helpful for me..
Navigation:
[Reply to this message]
|