[Top] [All Lists]

Re: SQL-NS and the BLOB data type

Subject: Re: SQL-NS and the BLOB data type
From: Joe Webb
Date: Wed, 27 Apr 2005 14:08:58 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Event data (as well as other SQLNS data) is stored as rows in a table in the SQL Server database. This allows SQLNS to process subscriptions and events in sets using joins rather than processing each subscription individually as a query. This is what makes SQLNS scale so well.
I'm sure you already know that TEXT and IMAGE columns not stored or
handled in the same manner as other datatypes such as INT or VARCHAR.
TEXT and IMAGE columns require special functions and statements to
insert and retrieve the data store in those columns. SQLNS does not have
the complexities of dealing with those datatypes built in.
So to answer your you cannot define event fields as TEXT
But all is not lost. Consider passing an ID column in for the event and
then get the data from the original datasource during formatting instead.

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS

RDV wrote:
In the ADF where you define your event data and the associated data
type, can event data be a BLOB data type?

Does the custom context formatter support this data type ... that is to
say does the BLOB work with Hashtable[] rawContent variable?

How would you access/retrieve this data from the rawContent variable?

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