strange error Message 50000 
Author Message
 strange error Message 50000

Hi,

We have a table that has been working ok until a couple of days
ago...we can't insert any row to it anymore. All other tables in the
same database are fine. The error message we've got is:

Msg 50000, Level 5, State 1
31417~USA
Msg 50000, Level 5, State 1
31417~USA:20001

It is a simple insert statement and all the non-null columns are
specified with a value. We did not specify any user-defined messages.
The database has plenty of space left. The server has not run out of
user connections.

Does anyone have any suggestions?

I appreciate your helps!

Sent via Deja.com http://www.***.com/
Before you buy.



Mon, 26 May 2003 03:00:00 GMT
 strange error Message 50000

This is a user defined error message that is being raised with the RAISERROR
statement, without adding a new number to the sysmessages table. My guess is
that there is an insert trigger that is firing off this message. Run
sp_helptrigger <tablename> to get the names of the triggers on the table.

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com

Quote:

> Hi,

> We have a table that has been working ok until a couple of days
> ago...we can't insert any row to it anymore. All other tables in the
> same database are fine. The error message we've got is:

> Msg 50000, Level 5, State 1
> 31417~USA
> Msg 50000, Level 5, State 1
> 31417~USA:20001

> It is a simple insert statement and all the non-null columns are
> specified with a value. We did not specify any user-defined messages.
> The database has plenty of space left. The server has not run out of
> user connections.

> Does anyone have any suggestions?

> I appreciate your helps!

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Mon, 26 May 2003 03:00:00 GMT
 strange error Message 50000
Thank you very much for your reply. Howerver, we are running Sql Server
6.5 here and it does not seem to have sp_helptrigger. We can't seem to
find another way to select all the triggers on a table.

Does you know a way to achieve this?

Thanks again!


  "Kalen Delaney"

Quote:

> This is a user defined error message that is being raised with the
RAISERROR
> statement, without adding a new number to the sysmessages table. My
guess is
> that there is an insert trigger that is firing off this message. Run
> sp_helptrigger <tablename> to get the names of the triggers on the
table.

> HTH

> --
> Kalen Delaney
> MCSE, SQL Server MCT, MVP
> www.InsideSQLServer.com
> Feed Someone for Free Today:
>      www.TheHungerSite.com




- Show quoted text -

Quote:
> > Hi,

> > We have a table that has been working ok until a couple of days
> > ago...we can't insert any row to it anymore. All other tables in the
> > same database are fine. The error message we've got is:

> > Msg 50000, Level 5, State 1
> > 31417~USA
> > Msg 50000, Level 5, State 1
> > 31417~USA:20001

> > It is a simple insert statement and all the non-null columns are
> > specified with a value. We did not specify any user-defined
messages.
> > The database has plenty of space left. The server has not run out of
> > user connections.

> > Does anyone have any suggestions?

> > I appreciate your helps!

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Wed, 28 May 2003 02:25:01 GMT
 strange error Message 50000
Please always state the version you are running whenever you post any
questions. There are lots of differences between the versions.

Use the database where the problem table is.

Use isql/w to execute this:

select UPDATETRIGGER =  object_name(updtrig), DELETETRIGGER =
object_name(deltrig), INSERTTRIGGER = object_name(instrig)
FROM sysobjects
WHERE name = 'insert the name of your table here'

6.5 does have sp_helptext, which you can use once you have the name of the
trigger. NULLS returned from above query means there is no trigger for that
action

HTH
--
Kalen Delaney
MCSE, SQL Server MCT, MVP
www.InsideSQLServer.com
Feed Someone for Free Today:
     www.TheHungerSite.com

Quote:

> Thank you very much for your reply. Howerver, we are running Sql Server
> 6.5 here and it does not seem to have sp_helptrigger. We can't seem to
> find another way to select all the triggers on a table.

> Does you know a way to achieve this?

> Thanks again!


>   "Kalen Delaney"

> > This is a user defined error message that is being raised with the
> RAISERROR
> > statement, without adding a new number to the sysmessages table. My
> guess is
> > that there is an insert trigger that is firing off this message. Run
> > sp_helptrigger <tablename> to get the names of the triggers on the
> table.

> > HTH

> > --
> > Kalen Delaney
> > MCSE, SQL Server MCT, MVP
> > www.InsideSQLServer.com
> > Feed Someone for Free Today:
> >      www.TheHungerSite.com



> > > Hi,

> > > We have a table that has been working ok until a couple of days
> > > ago...we can't insert any row to it anymore. All other tables in the
> > > same database are fine. The error message we've got is:

> > > Msg 50000, Level 5, State 1
> > > 31417~USA
> > > Msg 50000, Level 5, State 1
> > > 31417~USA:20001

> > > It is a simple insert statement and all the non-null columns are
> > > specified with a value. We did not specify any user-defined
> messages.
> > > The database has plenty of space left. The server has not run out of
> > > user connections.

> > > Does anyone have any suggestions?

> > > I appreciate your helps!

> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 28 May 2003 03:20:03 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Error: 50000, Severity: 0, State: 1

2. Error: 50000, Severity: 0, State: 1

3. Can't always get 50000 when raised from sproc

4. deleting 300,000 records with 50000 locks -Reply

5. deleting 300,000 records with 50000 locks

6. server not responding to port 50000

7. small(40000-50000 records) read-only DB recommendations

8. Newbie: Strange error message

9. Strange error messages!

10. strange error message

11. Problem: strange error message

12. Strange Error Message from SQL Server ODBC Driver


 
Powered by phpBB® Forum Software