Am Dienstag, 3. Juni 2014 16:46:47 UTC+2 schrieb Yaroslav Zemlyanukhin: > > Hi, Jeremy. > > > Some procedure is called by sequel in common way: > *call_mssql_sproc(:CallCalculator, args: call_calculator_args) * > And it throws: > *Sequel::DatabaseError: TinyTds::Error: Error 42999, Level 16, State 1, > Procedure CallCalculator, Line 49 Message: INSERT failed because the > following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL, > ANSI_WARNINGS, ANSI_PADDING'. 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.* > > BTW *CallCalculator *procedure is black box for me. > > *call_mssql_sproc *generates such expression: > *DECLARE @RC int; EXECUTE @RC = CallCalculator @CallList=N'<row > Calling="79121234567" Called="79121234567" Duration="60"/><row > Calling="79121234568" Called="79121234568" Duration="60"/>'; SELECT @RC AS > RESULT, @@ROWCOUNT AS NUMROWS* > > CONCAT_NULL_YIELDS_NULL should be set to ON when using tables with computed columns or indexed views ( see http://msdn.microsoft.com/library/ms176056.aspx ) Maybe your database option is still on CONCAT_NULL_YIELDS_NULL=OFF ?? ( and TSQL shell is sending a CONCAT_NULL_YIELDS_NULL=ON ) You should use the database profiler / extended events to trace which commands are send to the database by the TSQL Shell and Sequel .
Klaus -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
