January 7, 2011 at 1:42 am
Hi,
I'm trying to drop and create a table but I am getting error:
"INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
completed indices, constraints and permissions"
I have ANSI_PADDING ON and still the same. I also have ddl logging enabled.
Any advice well appreciated.
Thanks
January 7, 2011 at 2:01 am
TST1 (1/7/2011)
Hi,I'm trying to drop and create a table but I am getting error:
"INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
completed indices, constraints and permissions"
I have ANSI_PADDING ON and still the same. I also have ddl logging enabled.
Any advice well appreciated.
Thanks
Do you have any computed columns?
Also make sure that the setting for ANSI_PADDING is the same for session as for connection.
See this thread:
http://www.eggheadcafe.com/software/aspnet/31839813/ansipadding-woes-.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2011 at 2:15 am
Koen,
Sorry I should have mentioned that I have already done that. I think my issue here is pointing to the ddl trigger. I forgot to include another line of error above the one I posted
Msg 1934, Level 16, State 1, Procedure Log_DDL_Database_Events, Line 20
I'm a bit stuck on this.
January 7, 2011 at 7:00 am
TST1 (1/7/2011)
Msg 1934, Level 16, State 1, Procedure Log_DDL_Database_Events, Line 20
can you post its definition ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply