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
Hi Li,
I feel that this error is no way related to a Login issue. This MSG: 242
normally comes while you give invalid date format on
datetime data type.
set language us_english
declare @.k datetime
set @.k='25/07/2004'
Thanks
Hari
MCDBA
"Li" <Li@.discussions.microsoft.com> wrote in message
news:EE5A8215-D6C3-4A3B-BDBF-F10BFA93E58E@.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
>