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 |
|
MsLady
Starting Member
5 Posts |
 Posted - 2005-12-19 : 15:07:56
|
When the user does not have permissions to select, update, or delete a record I would like to write a custom error message to capture the sql error. I have tried "On Error Resume Next", which bypasses the error. Using an include file that will handle all the query errors that is accessible to the entire ASP application is the goal.Thank you for the assistance.MsLady |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-19 : 23:57:42
|
| Hi,you can use raiserror statement for custome error message in sql server . and refer sp_addmessage to add custome message in sql server.:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-20 : 01:05:13
|
| In ASP, I think you can make use of Error.Collection objectMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Custom SQL Error Message