Sending Instant messages from SQL

[madhu]

Hi

Can we send instant messages( say to a person logged onto
the MSN messenger) from SQL. Please provide pointers for
the same.

Thanks in Advance

Madhu

[Kimberly L. Tripp]

You can send emails - which is what IM does when someone isn't logged in BUT
I'm almost certain that you cannot send an instant message to pop up in MSN
Messenger (unless MSN Messenger apis are published and I don't think so but
I'm really not sure). You can send a pop-up message through net send and
that might be enough for you? I'm expecting that your main issue is that you
want to "immediately" notify someone of something...

There are two ways...
Create an alert which sends a pop-up to an operator (net sends and email
based paging are an option for the operator)
OR use xp_cmdshell to use net send

Things to be aware of:
(1) You should send things based on computer name NOT domain name because
the popups will go to the first machine that was logged into the domain
(meaning that if they have a test machine or other machine - that might be
the one that gets the messages). I always use a computer name for net send.
(2) These should go to Win2k, WinXP machines instead of earlier as Win9x
often has the netpopup or messenger services disabled (quite honestly, I
can't remember the right way of getting this to work on Win9x but if they're
all Win2k/xp, I *think* you're ok).

hth,
kt

**** Please reply only on the newsgroups! Include dml/ddl, when possible.
Thanks ****
Kimberly L. Tripp
Principal Mentor, Solid Quality Learning www.SolidQualityLearning.com
President, SYSolutions, Inc. www.SQLSkills.com

"madhu" <madhuve...@hotmail.com> wrote in message
news:085901c2c6b1$28590970$d4f82ecf@TK2MSFTNGXA11...

[Maciek Sarnowicz [MS]]

Documentation and downloads for Messenger API can be found at:
http://msdn.microsoft.com/downloads/default.asp?url=/downloads/topic.asp?url
=/msdn-files/028/001/359/topic.xml

Incorporating it into SQL would require writing an extended stored procedure
in C/C++ that can access the API and wrap it in SP so it can be called from
T-SQL. It can be done, but it's not fast-and-easy solution.

Alternatively you should look at Notification Services, a new add-on to SQL
Server that has an ability to notify users via various means (including
mail, Messenger and others) based on user-procided event definitions. Please
check this web site for more info:
http://www.microsoft.com/sql/ns/default.asp

Regards,
Maciek Sarnowicz

--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Kimberly L. Tripp" <Kimb...@nospam.sqlskills.com> wrote in message
news:eF8oJAAyCHA.2684@TK2MSFTNGP11...