Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure and ASP

Status
Not open for further replies.
oraclec

oraclec

Programmer
Dec 8, 2002
16
0
0
SG
Hi,

Is there a way to return the @@ERROR messages in (SQL Server 2000) stored procedures to the ASP page?

Essentially, I have a function that allows the user to import data into the SQL Server using BULK INSERT in an ASP Page. Should anything be amiss, (record exists etc.) I'd like to be able to return the error message from the DBMS to the user.

Thanks.

|~Oraclec~|
 
Sort by date Sort by votes

You can catch the @@error in a SP and return this value, then call this SP from the ASP.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
132
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
118
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
76
grnzbra
grnzbra
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
184
gmmastros
gmmastros
Andrzejek
  • Locked
  • Question
Data types and sizes
Replies
18
Views
174
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top