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.
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?
