Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Msgbox using stored procedure

    Is there a way to throw a message Box using a stored procedure?

  2. #2
    Join Date
    Aug 2002
    Location
    Pittsburgh, PA
    Posts
    10
    I'm not aware of any way of doing it through T-SQL, I would imagine you'd have to do something in VB or VBS in order to get a MsgBox to pop up for you. How it would be called from the Stored Proc, I'm not aware of (unless you exit out using xp_cmdshell and just have that call your exe or vbs file)

    So something like:

    Create proc msg_proc
    as
    (--any code--)
    exec master..xp_cmdshell 'c:\vbs\MessageBox.vbs'
    (--any other code--)
    return

    Hope this helps, its crude, but in my lack of expertise I'm not aware of a more elegant way.

    -Greg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •