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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Display Message From Stored Procedured

Author  Topic 

DMP
Starting Member

41 Posts

Posted - 2006-06-01 : 02:31:24
Hi,
Is it possible to display message from Strore procedured ?

Regards

Dmp

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-06-01 : 02:36:17
What kind of Message?
Error Messages then look for RaiseError in Book online

If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them.
Go to Top of Page

DMP
Starting Member

41 Posts

Posted - 2006-06-01 : 02:52:30
Thanks,
I don't required error message,
Basically I wish throw a message box to user like VB
If Msgbox("Do you want to continue ?",VBYesNo)=VbYes then
Continue the proc.
Else
Exit from Proc.


regards,
dmp
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-01 : 02:59:23
You have to do this in your front end application. SQL Server is a database engine, it does not have any user interface.


KH

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-01 : 03:10:33
quote:
Originally posted by DMP

Thanks,
I don't required error message,
Basically I wish throw a message box to user like VB
If Msgbox("Do you want to continue ?",VBYesNo)=VbYes then
Continue the proc.
Else
Exit from Proc.


regards,
dmp


The front end is for that scope. Use it. Dont think of doing that in sql

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -