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!

SQL-Server messaging

Status
Not open for further replies.
gaus

gaus

Programmer
Feb 5, 2001
92
0
0
US
Hi,
Does anyone know how to simpy return an informational message from a procedure/trigger without using RAISERROR? Something like VB's good-old msgbox?
Thanks,
Gary
 
Sort by date Sort by votes
does print not work for you.

e.g print 'Testing'

In query analyzer the text will apear on the messages tab.
 
Upvote 0 Downvote
I just found that about 30 minutes ago after trying to think of all of the ways (keywords) DB software tends to use to interact. It does exactly what I wanted. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
200
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
162
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
117
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
102
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
118
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top