Error:
What does this mean? It seems to make my process flow fail.
Diagnostic Message:
Error while making entry in table au_transactiondata Start Time:2012-08-23 11:13:06 End Time:2012-08-23 11:13:06 Run Time:93 ms[Invalid column name 'AU_activityStatus'.]
Cause: The log database is configured as case sensitive on the Server or Database Level.
Solution:
Case Sensitive and case insensitive is set as part of ‘COLLATION’.
For example:- if collation is “SQL_Latin1_General_CP1_CI_AS” then CI = Case Insensitive and CS = Case Sensitive.
COLLATION can be set at SERVER/DATABASE/COLUMN level.
You can check collation by:-
To check Server collation:- SELECT SERVERPROPERTY('COLLATION');
To check Database Collation : SELECT DATABASEPROPERTYEX('<dbname>', 'Collation') SQLCollation;
1 Comments