Error 242, Severity : 16, State : 3.

I tried to transfer the data from one application to another. Under the SQL Profile it stated Error 242, Severity : 16, State : 3. Any idea? SQL provide an logging "sa" error. I have checked the password for the application setup, odbc and SQL, they are a
ll identical. The applications have no problem
If you look in BooksOnLine you will see that the error is regarding data
conversion and not permissions.
"The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value."
You have at least one bad datetime value somewhere.
Andrew J. Kelly SQL MVP
"Li" <Li@.discussions.microsoft.com> wrote in message
news:A51B52EC-7EE8-4FDB-B7B6-6F85AF781557@.microsoft.com...
> I tried to transfer the data from one application to another. Under the
SQL Profile it stated Error 242, Severity : 16, State : 3. Any idea? SQL
provide an logging "sa" error. I have checked the password for the
application setup, odbc and SQL, they are all identical. The applications
have no problem
|||In the profiler trace, you have the spid that raised the error. Look for
the BatchStarting, or if captured - the StmtStarting event and look for the
values that were passed in this query that caused the error. It could be
erronoues data in this case, and not so much the odbc driver at fault.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.