microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Sending large notifications.

Subject: Re: Sending large notifications.
From: "Andy Wilbourn"
Date: Wed, 4 Jan 2006 07:26:59 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Joe's idea is the best method, but just thought I would share new features 
for SQL 2005. There is a new datatype XML that has a max of 2 GB. 
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/9198f671-8e61-4ca4-9c3a-859f84020e62.htm

Again this is new to SQL 2005, but may be appropriate for your needs.

"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> Since you're going to create a custom delivery protocol anyway, why
> not have SLQNS only process the primary key for the row you're
> interested in, and then have the custom delivery protocol grab the
> rest of the information for the row?
>
> HTH...
>
> -- 
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
> On 28 Dec 2005 01:33:43 -0800, "SQL Guy" <[email protected]> wrote:
>
>>I have some clarifications on Notification services.
>>
>>Following is the scenario
>>when a record is updated by a user, the same record needs to be sent to
>>all the other online users. And here we are using notification services
>>for pushing data from the server to the client machines.
>>
>>I have to send the entire dataset row(that got modified/added). So one
>>way of doing that is to get the XML of the Dataset and send this as a
>>part of the notification message by inserting the XML as one of the
>>notification fields. Here the problem that I am facing is, notification
>>fields have a restriction of 8000 characters. For the notification
>>fields, the long data types (like text, ntext etc) are not supported.
>>
>>The questions that I have is
>>Is there some way we can manipulate the notification message that is
>>sent? Only way I could find is setting a notification field with the
>>value. But the problem here is the 8000 characters' limit. Is there
>>any other way?
>>Thanks Much 



<Prev in Thread] Current Thread [Next in Thread>