Professional Web Applications Themes

Net Send - Microsoft SQL / MS SQL Server

Can I do a Net Send from a stored proc? If so, how?...

Sponsored Links
  1. #1

    Default Net Send

    Can I do a Net Send from a stored proc? If so, how?


    Sponsored Links
    John Guest

  2. #2

    Default Re: Net Send

    Use the extended SP to do the activity for you ...

    xp_cmdshell 'net send * testing'

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    SCT Software Solutions
    http://www32.brinkster.com/sqlvinod


    "John Hamilton" <com> wrote in message news:Ox$phx.gbl... 
    Vinodk Guest

  3. #3

    Default Re: Net Send

    Thanks all.



    "John Hamilton" <com> wrote in message
    news:Ox$phx.gbl... 


    John Guest

  4. #4

    Default Re: Net Send

    Hi
    Yes you can.
    DECLARE str VARCHAR(50)
    SELECT str = 'master..xp_cmdshell "NET SEND ' + host_name + ' ' + msg +
    '"'
    EXEC( str)

    "John Hamilton" <com> wrote in message
    news:Ox$phx.gbl... 


    Uri Guest

Similar Threads

  1. send data and then alter it after send
    By andros in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: April 13th, 09:45 PM
  2. Does Socket.send send all bytes?
    By Chris Reay in forum Ruby
    Replies: 2
    Last Post: November 4th, 08:22 PM
  3. ASP to send a Fax
    By Mike B in forum ASP.NET General
    Replies: 2
    Last Post: August 9th, 11:45 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139