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 |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2002-05-02 : 05:43:57
|
| Hi everybody, Is it possible to display a message box in T-SQL without using RAISERROR ? The problem with RAISERROR is that it has the caption "SQL Error" which I don't want because the message I want to show up is just a warning message. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-05-02 : 07:04:56
|
| You'll need to raise the message box in your presentation layer (VB, Access etc). You should be able to trap these errors in your front-end application. |
 |
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-05-03 : 05:42:07
|
| But what if someone updates directly at the back end using Enterprise Manager or Query Analyser ? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-05-03 : 06:18:16
|
| My suggestion would be to write a front end for these users. You're asking for trouble letting users edit the tables directly. |
|
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2002-05-06 : 02:47:05
|
| I won't be giving the permissions to the end-users to update the database directly at the back end. But I may have to give them to another programmer who is trying to integrate another application with my application, in which case if the outside application makes an updation which requires a warning, it would be raised from the back end itself. |
|
|
|
|
|
|
Message box