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

Re: Sending large notifications.

Subject: Re: Sending large notifications.
From: Joe Webb
Date: Wed, 04 Jan 2006 13:39:36 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Although the new XML datatype is available in SQL Server, my
preliminary tests indicate that it is not available as a datatype in
Notification Services. 

There is another new datatype called VARCHAR(MAX) that appears to be
available in SQLNS (again according to some very cursory testing I've
done, but admittedly I have thoroughly tested it out). It can store up
to 2^31-1 bytes of data. 

However, I'd question the efficiency of having SQLNS carry all that
data through the event-generation-distribution process. 

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 Wed, 4 Jan 2006 07:26:59 -0500, "Andy Wilbourn"
<[email protected]> wrote:

>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>