Hi
I am facing this issue while calling one proc into other and aslo i used a index veiw
SELECT INTO failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML
data type methods and/or spatial index operations.
Plz help