>>>Hi,
>>>
>>>I get error when updating a CursorAdapter cursor. The error says
>>>
>>>Insufficient column information for updating or refreshing
>>>
>>>
>>>I checked and it looks like the value assigned to the keyFieldList is correct. What else could be causing this issue? I also noticed that the value of my UpdateNameList property is fairly long (1508 characters); could it cause the error shown above?
>>>
>>>TIA.
>>
>>Is it CA for SQL Server? If yes, did you try checking if a command being send to SQL Server and what is this command (using SQL Profiler)?
>
>Yes, it is CA for SQL Server. And I don't know how to use SQL Profiler; will have to search for newbie article.
Simply invoke it from the Tools menu and then Run a trace. For now, nothing else is required. Although if you're running SSRS there will be too much extra stuff in the trace and you may want to filter by the application.
If it's not broken, fix it until it is.
My Blog