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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-25 : 07:38:29
|
| Carol writes "When I execute my stored procedures, I've a @RETURN_VALUE = -6, which means "Miscellaneous User Error Occurred" as stated by Microsoft. What sort of things should I look for in my stored procedures? OS: Microsoft Windows NT 4.0SQL Server Version: SQL Server Personla Edition 8.00.679(SP2)" |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-25 : 08:19:00
|
| Can you post a copy of a short stored procedure, along with a snippet of code that retrieves the error?You might try running the procedure in Query Analyzer to see if the same return value is generated. Query Analyzer also enhances your visibility into errors with Print statements and a debugger.Sam |
 |
|
|
|
|
|
@RETURN_VALUE = -6