Re: Error message assistance needed!
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 Sep 2005 16:30:21 -0700
Hi.
> What does this error message mean?
It means that your update failed, but worse, your DBA made some typos in the
update trigger or other stored procedure when calling the RAISERROR
function, or used an invalid msg_id number, or forgot to add the
user-defined error message to the sysmessages table in the Master database.
Therefore, SQL Server is unable to give you accurate information on why the
update failed. However, if you think about the possibilities of what could
go wrong, you may not need SQL Server to spell it out for you, and you can
fix the update problem yourself.
Have your DBA fix whatever is causing the error message problem in the
update trigger or stored procedure, whether he needs to fix the typos, or
fix the msg_id passed to the RAISERROR function, or add the user-defined
message to the sysmessages table in the Master database, or he can replace
it all with a user-defined state and severity for the error instead.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
<kblanding@xxxxxxxxxxxxxx> wrote in message
news:1125613206.641568.171380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> What does this error message mean? " ODBC-update on a linked table 'tbl
> name' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]RAISERROR
> could not locate entry for error ## in sysmessages." I am trying to
> complete what should be a pretty simple update query. Any thoughts?
>
.
- References:
- Error message assistance needed!
- From: kblanding
- Error message assistance needed!
- Prev by Date: Re: Summary Total of Two Date Fields
- Next by Date: Re: How to query the different format of the same name
- Previous by thread: Error message assistance needed!
- Next by thread: Records mimicking each other
- Index(es):
Relevant Pages
|
