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 setu
p, 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:B29BFC56-EBF9-48AB-8DE4-8898659BEC9C@.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.