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.
| Author |
Topic |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2010-05-20 : 10:03:45
|
| I'm having a bit of a nightmare with SET ANSI_NULLS ON|OFFI need to list out all the stored procedures in my db and what each of their ansi nulls setting is....any pointers appreciated |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2010-05-20 : 10:08:26
|
| Just in case anyone else needs this, my googling skills came back....select object_name(sys.all_sql_modules.object_id) as Name, uses_ansi_nulls from sys.all_sql_modules inner join sys.objects ON sys.all_sql_modules.object_id = sys.objects.object_id where objectproperty(sys.all_sql_modules.object_id, 'IsProcedure') = 1 AND is_ms_shipped = 0 order by name |
 |
|
|
|
|
|
ANSI NULLS setting for all stored procedures