How to Send a SQL Server notification to Messenger

SQL Server Notification Services

Index ‹ SQL Server
- Archive
  - Windows Vista
  - ISV
  - Visual C#
  - Game
  - SQL Server
  - VFP
  - Architecture
  - Smart Device
  - VS 2008
  - VS Express
  - Dotnet
  - IE
  - SharePoint
  - Office
  - Windows Live
  - Windows Forms
  - VC++
  - VB
  - Visual Studio

- Previous
  - 1
    - Moving SSRS directory Hello - I'm new to reporting Services. I have just configured SSRS using the RS configuration manager. It has created the RS directory and databases on my "C" drive, how can I move this to the "D" drive Tag: How to Send a SQL Server notification to Messenger
  - 2
    - SQL Server Agent Are there any down sides to running the SQL Server Agent What is this agent used for Tag: How to Send a SQL Server notification to Messenger
  - 3
    - Minimun SP Level for Cluster Upgrade I'm upgrading MSSQL2000 (RTM) cluster to 2005. I haven't seen any information regarding a minimum service pack level for 2000. This upgrade just makes me overly caution. Tag: How to Send a SQL Server notification to Messenger
  - 4
    - SQL Server 2000 Job Problems I'm trying to run a T-SQL job, but it won't let me use more than 3200 characters in the script. Do I have to create a DTS package to run this script since it is much longer than 3200 chars Or is there an easier way to do this -Kyle Tag: How to Send a SQL Server notification to Messenger
  - 5
    - Protect from SQL Injection? Hi, Just read about SQL injection, and tested it out with sample database, and it does hack my database, the article show to prevent SQL injection by using application code to remove those keywords and change single quote to double quote, is there any method to prevent SQL injection directly using the database system itself, maybe stored procedure or anything Thanks. Tag: How to Send a SQL Server notification to Messenger
  - 6
    - Deployment Of SSIS With Config Files I went through other threads and links on this subject. Still one thing which concerns me is the config files. My current folder path is C:\Karunakaran\folder1\folder2\ Under folder2 I have the following files 4 dtsx files 1 .database file 1 .dtproj file 1 .dtproj.user file 1 .sln file 1 .suo file Config folder ( C:\Karunakaran\folder1\folder2\Config\) common.dtsConfig oracle.dtsConfig Based on some of the threads, when I enabled package configuration, I changed the path from C:\Karunakaran\folder1\folder2\Config\common.dtsconfig -> common.dtsconfig Once I did this, when I open the project I get a dozen of warning similar to the one below Warning loading <package1>.dtsx: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed. What am I doing wrong here If I have to deploy this to another box, what should I do to ensure that nothing breaks once its copied / installed Thanks Tag: How to Send a SQL Server notification to Messenger
  - 7
    - Possible to stop SSRS GUI from destroying hand rolled mdx in datasets by silently reverting to design mode? Since as soon as you extend your mdx datasets manually you can no longer switch back into design mode without losing your changes, right If that's the case, is there some way to disable design mode completely i'm finding that the GUI has the tendency to SILENTLY revert the dataset editor back to design mode while I'm busy editing a layout, thereby losing my carefully crafted MDX. Tag: How to Send a SQL Server notification to Messenger
  - 8
    - why any function related to prior period in my data does not work? Hi, all, I am encountering a very strange problem that I cant get any value for prior period for my KPI. E.g, I am defining a KPI goal which will be the value of the prior period multiplies 1.2, but then no result returned for this definition, only result returned for value of current period, if I defined the goal as anything of current period Why is that I am very much looking forward for your help. Thanks. With best regards, Yours sincerely, Tag: How to Send a SQL Server notification to Messenger
  - 9
    - new to SQL - create table command question hi can someone please explain the following please why does this fail with specified owner testdb does not exist or you do not have permissions create testdb.testtable ( testval int ) yet if i create testdb and then run the following against this new db create testtable ( testval int ) command command completes successfully......what am i not understanding or doing wrong thank you Tag: How to Send a SQL Server notification to Messenger
  - 10
    - SP_Change_Users_Login I am moving several databases that belongs to a single application from MSSQL2000 to MSSQL2005. After sucessfully moved and converted the databases I need to fix the users login and I am using sp_change_users_login procedure to do so. My questions are: I have an application user that needs to be fixed in several databases - how can I fixed the login all once Also is there a way to turned the check_policy off at the same time I fixed the logins thank you Tag: How to Send a SQL Server notification to Messenger
  - 11
    - Trying to figure out number of pages in report Greetings, I have a report that is created that is typically 2-3 pages long. I've tried the "ExecutionInfo.NumPages" but it always results in "1" as the answer. Code is something like this: ============ ... Dim reportHistoryParameters As sqlprod1_res.ParameterValue() = Nothing Dim SessionId As String Dim execInfo As New ExecutionInfo Dim execHeader As New ExecutionHeader() Dim result As Byte () = Nothing Dim format As String = "PDF" Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>" Dim extension As String = "" Dim encoding As String = "" Dim mimeType As String = "" Dim warnings As sqlprod1_res.Warning() = Nothing Dim streamIDs As String () = Nothing result = rs.Render(format, devInfo, extension, encoding, mimeType, warnings, streamIDs) execInfo = rs.GetExecutionInfo() Dim Pages As Integer = execInfo.NumPages ============ Also tried to count streams with the same result. Any ideas Thanks Dan Ribar Tag: How to Send a SQL Server notification to Messenger
  - 12
    - Login scripting to a file I am new to DMO and I am trying to find a way where I can create a script file containing all server logins. THis needs to run on a daily basis. Anyone have any examples to share Tag: How to Send a SQL Server notification to Messenger
  - 13
    - truncation error message Ok, this is starting to drive me nuts, I've been trying to get this to work for 2 days now. I have a .csv file that I'm reading and importing the data into my table. I defined Derived columns for the type and the lengths as well. I have one column that keeps kicking out this error: The column in the db has a length of 50, the column in my derived column is set to 50, now there are some strings in the colum from the csv file that contain more then 50 characters so I have this in my derived column section: to get the first 50 characters. (DT_WSTR,50)NAME [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "NAME" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. so to some it up. My field (name) in my .csv file can contain 2 to 80 characters but I only want the first 50 and if the field contains greater then 50 characters I'm getting the error above. Has anyone else run into something like this If so how did you get it working Tag: How to Send a SQL Server notification to Messenger
  - 14
    - SQL Parameter and wildcards, how to make it work? Hello, I have what should be a very simple problem, but I cant solve it. I want to have a stored procedure return a table query (no problems here) but I also need to supply several parameters to the stored procedure (again, no problem!) Here is the problem, I need to be able to supply a wildcard into the stored procedure as an argument somehow. I can do this already, but the results are incorrect!!! It seems like when local variables are used, the wildcard argument gets ignored. for example, I have included the following example: DECLARE @Dv_id nchar ( 15 ) SET @Drv_id = '%' SELECT Diver .*, ( ROW_NUMBER () OVER ( ORDER BY Dv_id )) as RowNum FROM Diver WHERE Dv_id LIKE @Dv_id SELECT Diver .*, ( ROW_NUMBER () OVER ( ORDER BY Dv_id )) as RowNum FROM Diver WHERE Dv_id LIKE '%' OK, this is an example of my problem, the results I get from this are that the fist SELECT return 0 rows. The second SELECT returns the correct number of rows (everything in the table). Why is there a difference between: WHERE Drv_id LIKE @Drv_id and WHERE Drv_id LIKE '%' The wildcard statement '%' is supposed match everything, correct It seems like the local variable SET command syntax eats up my value of '%' and turns it into a NULL. Is there any way around this Tag: How to Send a SQL Server notification to Messenger
  - 15
    - SSIS Logs Following the blog of jamie, I was trying to aply it to my project... but my requirments are a little different than him... http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx CommentPosted=true#commentmessage I have inside the ControlFlow several sequence containers and inside each container I have several dataflows. I want to get the time of each dataflow execution and the rows inserted in each. So I added a row count transform for each dataflow and added a global variable to save the rows count value. In each dataflow I need to initialize this global variable to 0. And my problem is that using event handlers in OnPostExecute it repeats several times for each dataflow... how can I save info only once for each dataflow using eventhandlers How can make eventhandler execute only once to save the related information for each dataflow Understood regards Code Snippet "INSERT INTO SSISLog(TaskStartTime, EventType, PackageName, TaskName, PackageDuration, ContainerDuration, InsertCount, UpdateCount, DeleteCount, Host) VALUES( '" + (DT_STR, 4, 1252) DATEPART("yyyy", @[System::EventHandlerStartTime]) + "-" +(DT_STR, 4, 1252) DATEPART("mm", @[System::EventHandlerStartTime]) + "-" +(DT_STR, 4, 1252) DATEPART("dd", @[System::EventHandlerStartTime]) + " " +(DT_STR, 4, 1252) DATEPART("hh", @[System::EventHandlerStartTime]) + ":" +(DT_STR, 4, 1252) DATEPART("mi", @[System::EventHandlerStartTime]) + ":" +(DT_STR, 4, 1252) DATEPART("ss", @[System::EventHandlerStartTime]) +"', 'OnPostExecute', '" +@[System::PackageName]+"' , '" +@[System::TaskName]+"' , "+ (DT_STR, 6, 1252)DATEDIFF( "ss", @[System::StartTime] , GETDATE() ) + ", "+ (DT_STR, 6, 1252)DATEDIFF( "ss", @[System::ContainerStartTime] , GETDATE() ) + ", " + (DT_STR, 4, 1252) @[User::SSIS_Rows] + ", 2, 3, '"+ @[System::SourceDescription] +"')" Tag: How to Send a SQL Server notification to Messenger
  - 16
    - Received message constantly processed. Hello, when is seemd that everything works some weird behaviours comes out. I try to summarize the problem without to post the complete code. Service Broker is set to have a dialog between two databases on the same SQL Server instance. The Initiator queue has retention=on and there is an activation SP to handle errors and Target's end dialog message. The Target queue has retention=off, MAX_READER =1 and there is an activation SP to receive the message (WAIT FOR (RECEIVE (1) ...), TIMEOUT 30000 and do something with this message (sample insert into a DB). The conversation has a Timeout Dialog to end the dialog after a while. The problem that the message is constantly processed. The Process doens't stop is I end the dialof after the processing either. n.b.the Receive is within a Transation that I commit at the end. some other informations that in the meanwhile I found out : This was my complete WAIT FOR(RECEIVE : WAITFOR ( RECEIVE top(1) -- just handle one message at a time @message_type=message_type_id, --the type of message received @messagetypename=message_type_name, @message_body=message_body, -- the message contents @dialog = conversation_handle -- the identifier of the dialog this message was received on FROM [TargetQueue] ), timeout 1000; if (@@ROWCOUNT = 0) BEGIN COMMIT; BREAK; END IF I delet TIMEOUT 1000, everything works as expected ... Inside if (@@ROWCOUNT = 0)BEGIN..END I wrote also an Insert into a table to see wheter the end of the queue was reached but this insert never occurs (neither with not without timeout) I'm happy that it works what if this is the solution, it make no sense to me! Any ideas Thank you! M.B. Thank you very much M.B. Tag: How to Send a SQL Server notification to Messenger
- Next
  - 1
    - Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008) OK, I have tried just about everything over the past 9 hours. I think I've read through every forum regarding anything similar to errors with SMO and TransferData(). However, I still can't fix my problem. What I'm trying to accomplish is a workaround for deploying my database application using ClickOnce. Since I can't include the database when upgrading (which would wipe out users' data), I want to have a 'Master Database' that is used as a reference to both initially create, and to selectively update, the main 'User Database'. I'm not sure if that is possible, yet...because SMO is not working for me (I'm sure there are more laborious methods to do what I want, but SMO should work...I can't help but think there is a bug). Here is my current code: Code Snippet 'Master Database Dim dbName_Master As String Dim SqlCon_Master As SqlClient.SqlConnection = New SqlClient.SqlConnection( My .Settings.LM_Master_SQLConStr) SqlCon_Master.Open() dbName_Master = SqlCon_Master.Database.ToString() Dim SC As New ServerConnection(SqlCon_Master) Dim srv As New Smo.Server(SC) 'Verify User Instance connection Console.WriteLine( "User Instance Server: " & srv.InstanceName.ToString) 'Select the Master Database as the source db Dim dbMaster As Smo.Database dbMaster = srv.Databases(dbName_Master) 'Define a Transfer object and set the required options and properties. Dim xfr As Smo.Transfer xfr = New Smo.Transfer(dbMaster) xfr.CopyAllObjects = True xfr.CopyAllUsers = True xfr.CopyData = True xfr.CreateTargetDatabase = True xfr.DropDestinationObjectsFirst = True xfr.DestinationDatabase = "TestDB" xfr.DestinationServer = srv.Name xfr.DestinationLoginSecure = True xfr.CopySchema = True xfr.Options.WithDependencies = True xfr.Options.ContinueScriptingOnError = True xfr.Options.NoIdentities = False xfr.Options.NoCollation = True xfr.Options.Indexes = True xfr.CopyAllDefaults = True xfr.Options.AllowSystemObjects = True xfr.Options.DriAll = True xfr.Options.XmlIndexes = True 'Script the transfer. Alternatively perform immediate data transfer with TransferData method. Dim StrColl As New System.Collections.Specialized.StringCollection StrColl = xfr.ScriptTransfer() For Each str As String In StrColl Console.WriteLine(str) Next xfr.TransferData() The final error is: ***** DtsRuntimeException was unhandled... Exception from HRESULT: 0xC0011008 ***** I also have not seen any examples or documentation on how to store the new database in a specific location on the hard drive, once the transfer is complete. In fact, SMO has surprisingly little documentation that I can find (which is why the code above may seem a little redundant when setting the xfr options...). I would really appreciate some help. Thank you, AL Tag: How to Send a SQL Server notification to Messenger
  - 2
    - Report Builder Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build What are the limitations of using Report Builder with SQL Server Databases Tag: How to Send a SQL Server notification to Messenger
  - 3
    - 64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component. However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a small SQL Agent Job that just sends a test email via the sp_send_dbmail command and that works properly. However if I deliberately create a malformed parameter in the sp_send_dbmail command to 'break' it...no notification of a job failure message is sent. I have verified that the service_broker component is enabled...and the status of database mail in the MSDB database is 'started.' We have setup several other 32-bit SQL Server 2005 systems using database mail...and they all work flawlessly. After reviewing existing message posts...I am unsure if there is a problem with database mail on a 64-bit SQL Server box. Some say 'yes' other say 'no'. There are several MSDN notes about the problem...however these appeared prior to the release of SP1 of SQL Server 2005. Thank you for your assistance. ...cordell... Tag: How to Send a SQL Server notification to Messenger
  - 4
    - importing from excel into SQL Server 2005 changing values to NULL I can't figure this one out... I have an Excel spreadsheet (Excel 2003 format) with a column of values. The column is formated to General (although I've tried it formated to text). The values are alphanumeric. However, there are a few values that are completely numeric. Example: _ITEMNUMBER_ 1-528 K214-5 184PR 45678 As can be seen, the last value is completely numeric. I am importing into a table with one column that is formated as nvarchar(50). I use dtswizard.exe and do a simple import into the table and the alphanumeric values import just fine but anytime a value is completely numeric it has a NULL value in the table instead of the value that should be there. I've tried changing the format of the column to nchar, char, etc, etc. Always comes in NULL. Any ideas Tag: How to Send a SQL Server notification to Messenger
  - 5
    - Could not load package because of error 0xC001000A I am trying to run an SSIS Package by using DTRun.exe this way C:\Documents and Settings\Fahad>dtexec /SQL DataDownload /Conn "Data Source =TriMurti;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate =False;Password=gamba" /U sa /P gamba And the outcome of the command was Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:03:52 AM Could not load package "DataDownload" because of error 0xC001000A. Description: The specified package could not be loaded from the SQL Server database. Source: Started: 9:03:52 AM Finished: 9:03:52 AM Elapsed: 0.25 seconds ----------------------------- Any help in this will sincerely be appreciated. Fahad Tag: How to Send a SQL Server notification to Messenger
  - 6
    - Disabling extended stored procedures for security Our security team wants us to disable access to (or drop) all of the built-in extended stored procedures in MSDE 2000 as they feel it is a vulnerability. Where can I find out which extended procs are safe to disable or how we can disable them during install time Or, is the security team being too cautious and we should just tell them to leave these intact Tag: How to Send a SQL Server notification to Messenger
  - 7
    - The SSIS package does not run using SQL Server Agent job Dear All, My SSIS package is "Extract" data from Oracle and Load into SQL Server. The SSIS package does not run when I call the SSIS package from a SQL Server Agent job step I have gone through all the steps in the doc http://support.microsoft.com/kb/918760 , but it still doesn't work. Is it because of connection to "Oracle" database and SQL Server Agent service could not recognise the Authentication information to Oracle Why I am saying this is becuase it works if I change the package to "Extract" data only from SQL Server. Anyone has experience on this problem Many Thanks in Advance John Tag: How to Send a SQL Server notification to Messenger
  - 8
    - smalldatettime declare @ValueDate smalldatetime set @ValueDate = '21/05/2007' select @ValueDate error: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. Please note, if '05/21/2007' is used then there is no error. How is it possible to get 'dd/mm/yyyy' as above to work please Thanks Tag: How to Send a SQL Server notification to Messenger
  - 9
    - missing borders when SSRS report is rendered in Sharepoint Hi , I am trying to host an SSRS report as a web part in Microsoft Sharepoint 2007. All the elements and data come out well except that a few borders are missing in the rendered report. What could be the possible cause and solution for this. Please suggest. Tag: How to Send a SQL Server notification to Messenger
  - 10
    - Reporting services permission denied on microsoft access linked I have a Microsoft access 2003 database with tables linked to a number of "SharePoint lists" I do this by going to File -> Get External Data -> Link Tables. A new window pop-ups in which I select Files of Type to be Windows SharePoint Services.. Then I select the correct site.. Then select the correct Lists.. Then access correctly links the tables to the SharePoint lists. When I Open reporting services and connect to this access database. "Using the Test Connection" (Jet 4.0) its successful" When i when create a new report and select the new datasource i have just created and in reporting services I write a select all query on one of the tables in access I get this error: An Error occurred while executing query. You do not have the necessary permissions to use the ��object. Have your system administrator or the person who created this object establish the appropriate permissions for you. Catastrophic Failure. I have tried this on the super admin machine and still get the same error Any suggestions or help Tag: How to Send a SQL Server notification to Messenger
  - 11
    - IDENTITY_INSERT Issue INSERT INTO dbo.my_table (table_key) VALUES (007) -- Msg 544, Level 16, State 1, Line 1 -- Cannot insert explicit value for identity column in table 'my_table' when IDENTITY_INSERT is set to OFF. SET IDENTITY_INSERT dbo.my_table ON INSERT INTO dbo.my_table(table_key) VALUES (007) SET IDENTITY_INSERT dbo.my_table OFF -- Msg 1088, Level 16, State 11, Line 2 -- Cannot find the object "dbo.my_table" because it does not exist or you do not have permissions. I know for certain that I have read/write permissions on this server. Is this somehow restricted to only the dba or something I appreciate all of this community's help with my basically non-stop flow of questions. You're a huge chunk of help, and it's deeply appreciated!! Jim Work Tag: How to Send a SQL Server notification to Messenger
  - 12
    - SQLIS Checksum Install Problems For detecting delta records, I'm a big fan of SQLIS' checksum transform. I'm having difficulty in it's install on my current machine, however. After the installation and the new transform is added to my DataFlow toolbox... I can't open the UI for the transform to define the checksum. Instead, I get the following error: =================================== Could not load file or assembly 'Microsoft.ExceptionMessageBox, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft Visual Studio) ------------------------------ Program Location: at Konesans.Dts.Pipeline.ChecksumTransform.ChecksumTransformUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections) at Microsoft.DataTransformationServices.Design.DtsComponentDesigner.StartComponentUI(Boolean startGenericUI) Anyone have any suggestions Thanks in advance. Tag: How to Send a SQL Server notification to Messenger
  - 13
    - Count 4 tables I am trying to get a count of rows in 4 tables at once. Output: Table1 Table2 Table3 Table4 12345 143 892626 28428 Or maybe even Table Count Table1 12345 Table2 143 Table3 892626 Table4 28428 Thanks, Cory Tag: How to Send a SQL Server notification to Messenger
  - 14
    - Duplicates Hi! Grateful for some help as a newbie... I have a OLE db SQL command: SELECT DISTINCT convert (char(8),date,112) as day,...etc Resulting in error "Violation of PRIMARY KEY constraint 'PK_Dim_Date "... so Column Day in Dim_date contains duplicates. I suppose i need a delete in Lookup or how would I eliminate duplicates in Dim DELETE day from dim_date where day in(Select day from date ... Tag: How to Send a SQL Server notification to Messenger
  - 15
    - Adding Columns and rows in pivot table to Excel 2007 Hi, I am developing Excel pivot table reports pointing to Analysis services Cube (SSAS 2005). I tried to add Columns and rows inside the pivot table but it doesnt allow me to do it. Is there a way to achieve this kind of scenario in Excel 2007 apart from converting pivot table into a normal table and manipulating it. I once read that pivot table is a single object and we cannot manipulate(i.e. add new rows and columns) inside the pivot table. Thanks Kiran Tag: How to Send a SQL Server notification to Messenger
  - 16
    - Error: Incorrect syntax near the keyword 'DECLARE' Can someone tell me why I am getting this error: Msg 156, Level 15, State 1, Procedure fn_FunctionName, Line 11 Incorrect syntax near the keyword 'DECLARE' CREATE FUNCTION fn_FunctionName(@ElementID int) RETURNS TABLE AS RETURN --create a table (o) to hold the outcomes returned by fn_GetDescendantsByClass DECLARE @OUTCOMES TABLE (ID int, PARENT_ID int, CLASS_ID int, TITLE nvarchar(255)) INSERT @OUTCOMES SELECT * FROM fn_GetDescendantsByClass(@ElementID, 302) SELECT DISTINCT sl.JOB_ID, o.ID FROM @OUTCOMES o INNER JOIN (SELECT START_SCENE_ID, DEST_SCENE_ID AS JOB_ID FROM SCENE_LINK WHERE PROPERTY_ID IN (97, 151)) AS sl ON o.ID = sl.START_SCENE_ID GO Thanks very much Tag: How to Send a SQL Server notification to Messenger

julianenrique

Hello,

I'm trying to send a SQL Server notification to MSNMessenger and also to Yahoo Messenger, but I didn't find the way. If you have some information about it, please answer this question as soon as possible.

Thank you so much

Top

Re: How to Send a SQL Server notification to Messenger

Joe Webb

You'll need to create a custom delivery protocol to send to a IM service. I believe that there are companies out there that offer gateway services to IM, SMS, etc, but I don't know of one off-hand.

HTH...

Joe

Top

Re: How to Send a SQL Server notification to Messenger

julianenrique

Thank you for your answer,

But I'm interested to find some code to send a message to diferents IM providers like MSN, yahoo, etc. If you have or know and API to get this goal, please help me. Thanks a lot.

Top

Re: How to Send a SQL Server notification to Messenger

Joe Webb

You may want to check out Live Communications Server.

http://office.microsoft.com/en-us/communicationsserver/FX101729111033.aspx

http://en.wikipedia.org/wiki/Microsoft_Office_Live_Communications_Server

Perhaps you could create a custom delivery protocol that employs LCS to deliver the message

HTH...

Joe

Top