Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fredong
Yak Posting Veteran
80 Posts |
 Posted - 2005-04-22 : 10:57:38
|
| I need a Sql prophet to interpret this error for me which I received from my sql server.Thanks.Error: 50000, Severity: 16, State: 2k |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 11:10:38
|
this happens when you call RAISERROR('This is a test', 16, 2)Go with the flow & have fun! Else fight the flow  |
 |
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-04-22 : 11:39:58
|
| what flow and what test?k |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 11:41:24
|
| you can replace "this is a test" with any other string.50000+ are user defined error messages that are called with RAISERROR.Go with the flow & have fun! Else fight the flow |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-04-22 : 11:43:55
|
| I am not developer how do I replace it?Does this error cause any harm to the system?k |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 11:55:42
|
| first tell us what do you do when you get this error?is it in a stored procedure?it doesn't cause any harm to the system.it's probably there for a reason. it may mean that you business logic does something it's not suppose to or something else. as i said it's a user defined error so the developer put it there.Go with the flow & have fun! Else fight the flow |
|
|
|
fredong
Yak Posting Veteran
80 Posts |
Posted - 2005-04-22 : 11:59:13
|
| I did nothing with this error.. and I do not where it is located in the store procedure because this software is a proprietory software. It there way to locate which store procedure is raising this error?Thanks.k |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-04-22 : 12:00:52
|
| can you run SQL profiler?with it you can what calls are being made to the sql server.why don't you contact the software vendor?Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
Error: 50000, Severity: 16, State: 2