Sending Message (SQL)

[rkbnair]

Is it possible to send a message to another user from VB application via SQL
Server. I mean I want to send a message to a another user of the same database
(MS SQL 7.0)

Thanks,
RK.

[rkbnair]

David, thanks for the reply. Wherre can I get some documentation for this.
Which table should be queried in order to get the messages?

RK.

"David Satz" <davidNOSPAMsatz@yahoo.com> wrote:
>AFAIK not thru any native TSQL functionality, but you could design one
>yourself - it would not be that easy, but VB (if i remember) has some event
>in the application that can runa timer. The timer could run a query looking
>for messages.
>--
>HTH,
>David Satz
>Principal Web Engineer
>Hyperion Solutions
>{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS
}
>(Please reply to group only - emails answered rarely)
>-----------------------------------------------------------------
>"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
>news:3c34d601$1@147.208.176.211...
>>
>> Is it possible to send a message to another user from VB application via
>SQL
>> Server. I mean I want to send a message to a another user of the same
>database
>> (MS SQL 7.0)
>>
>> Thanks,
>> RK.
>>
>
>

[David Satz]

AFAIK not thru any native TSQL functionality, but you could design one
yourself - it would not be that easy, but VB (if i remember) has some event
in the application that can runa timer. The timer could run a query looking
for messages.
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
news:3c34d601$1@147.208.176.211...
>
> Is it possible to send a message to another user from VB application via
SQL
> Server. I mean I want to send a message to a another user of the same
database
> (MS SQL 7.0)
>
> Thanks,
> RK.
>

[Daniel Reber]

Create a message table with what ever fields you need plus a bit field to
set if the message has been read or not. In the app add a timer control and
on the Timer() event add code to retreive all messages that have not been
read yet.

HTH
Daniel Reber
Datamasters, Inc


"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
news:3c34d601$1@147.208.176.211...
>
> Is it possible to send a message to another user from VB application via
SQL
> Server. I mean I want to send a message to a another user of the same
database
> (MS SQL 7.0)
>
> Thanks,
> RK.
>

[David Satz]

see Daniel post - but basically it is a total do it yourself solution.

"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
news:3c35ab8d@147.208.176.211...
>
> David, thanks for the reply. Wherre can I get some documentation for this.
> Which table should be queried in order to get the messages?
>
> RK.
>
> "David Satz" <davidNOSPAMsatz@yahoo.com> wrote:
> >AFAIK not thru any native TSQL functionality, but you could design one
> >yourself - it would not be that easy, but VB (if i remember) has some
event
> >in the application that can runa timer. The timer could run a query
looking
> >for messages.
> >--
> >HTH,
> >David Satz
> >Principal Web Engineer
> >Hyperion Solutions
> >{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } {
VSS
> }
> >(Please reply to group only - emails answered rarely)
> >-----------------------------------------------------------------
> >"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
> >news:3c34d601$1@147.208.176.211...
> >>
> >> Is it possible to send a message to another user from VB application
via
> >SQL
> >> Server. I mean I want to send a message to a another user of the same
> >database
> >> (MS SQL 7.0)
> >>
> >> Thanks,
> >> RK.
> >>
> >
> >
>

[rkbnair]

Daniel/David.

Thanks for your guidelines. It was so easy to do. It is working perfect.

Thanks you both
"Daniel Reber" <dreber@dminconline.com> wrote:
>Create a message table with what ever fields you need plus a bit field to
>set if the message has been read or not. In the app add a timer control
and
>on the Timer() event add code to retreive all messages that have not been
>read yet.
>
>HTH
>Daniel Reber
>Datamasters, Inc
>
>
>"rkbnair" <rkannale@solus.oceaneering.com> wrote in message
>news:3c34d601$1@147.208.176.211...
>>
>> Is it possible to send a message to another user from VB application via
>SQL
>> Server. I mean I want to send a message to a another user of the same
>database
>> (MS SQL 7.0)
>>
>> Thanks,
>> RK.
>>
>
>

[Peter Belbin]

Yes, it is possible, if all your ducks are sitting in a row.

You can knock up a T-SQL procedure which uses runs a command line prompt
to send the message to the client using the net message command.

The only problem with this is that it relies on the client running the messenger
service in order to catch the message at the client, and cause it to be displayed
on the screen.

Mostly this is already running, but, depending on the client, it might not.
Mostly WinNt clients will have it running all the time. Win9x might not,
however.

peter.



"rkbnair" <rkannale@solus.oceaneering.com> wrote:
>
>Is it possible to send a message to another user from VB application via
SQL
>Server. I mean I want to send a message to a another user of the same database
>(MS SQL 7.0)
>
>Thanks,
>RK.
>