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 |
|
Saeed
Starting Member
39 Posts |
 Posted - 2002-12-16 : 16:17:00
|
| How do you display a message or a variable and pause the spr ....Thanks |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-16 : 16:26:55
|
| If you are using sql2k go to Query Analyzer drill down to the stored procedures right click on one and choose debug. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-16 : 16:27:48
|
| You can return a message using RAISERROR (preferred) or PRINT. You can use WAITFOR to pause execution of the sproc, but there's very little point in doing so. The user will not see the error message until the sproc completes execution, nor can they interrupt the sproc even if it is paused. Such a feature must reside in the user interface, not the database code.RAISERROR, PRINT and WAITFOR are documented in Books Online. |
|
|
|
Saeed
Starting Member
39 Posts |
Posted - 2002-12-16 : 16:51:55
|
quote:
If you are using sql2k go to Query Analyzer drill down to the stored procedures right click on one and choose debug.
How Do you drill down? all I see is a blank window where i can just type in my SQL statement in it...!!!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-16 : 17:18:00
|
| Well you must use SQL2k in order to have this feature. From Query Analyzer, just hit F8. Now go to the object browser that was just opened and follow ValterBorges' instructions. |
|
|
|
|
|
|
Display and pause