sql server notification services: Hi,

I have a requriement where the I need to push the information to the =
"text" field.=20
When I tried to modify the structure of the events table. It gave me a =
following error.=20

C:\SS_Argos_Rakya\NotificationService\ApplicationDefinitionFile\ArgosRAPA=
DF.xml(
508,4): error NS9116: The field type is not valid. Field type must be =
one of the

standard SQL Server types but may not be text, ntext, image or =
sql_variant.

FieldName: RuleSet

FieldType: text

EventClassName: RuleSetEvents


I cannot put varchar or char datatype... as the information can have =
details more than 4000 characters.
I need the table datatype to be text, so what could be a work around for =
this.=20

Regards,

Hello Andy,

Thanks for the reply. No I am using SQL Server 2000. The notification
service is installed as a seperate component.

As I have a requirement, I need to push the information stored in my
local database as Text to the another Database remotely. I am using
Notification service.

Yes the information crosses more than 8000 characters so I cannot put it
as VARCHAR too.

Please shed some light as to what is a workaround for this problem.

Thanks!!!
Yogesh Kadalgikar

I am not sure what datatypes are allowed, but in order to update a text =
field you have to do some funky stuff like setting a pointer to where to =
start.

VarChar will allow up to 8000 characters, but that is limited based on =
other columns defined and their width. The data page is 8K.

Are you using SQL 2000 or 2005? 2005 allows for you to have XML =
datatypes. The only limit is a 2 GB storage space for XML data, which I =
would hope you don't exceed.
[quoted text, click to view]
Hi,

I have a requriement where the I need to push the information to the =
"text" field.=20
When I tried to modify the structure of the events table. It gave me a =
following error.=20

=
C:\SS_Argos_Rakya\NotificationService\ApplicationDefinitionFile\ArgosRAPA=
DF.xml(
508,4): error NS9116: The field type is not valid. Field type must be =
one of the

standard SQL Server types but may not be text, ntext, image or =
sql_variant.

FieldName: RuleSet

FieldType: text

EventClassName: RuleSetEvents


I cannot put varchar or char datatype... as the information can have =
details more than 4000 characters.
I need the table datatype to be text, so what could be a work around =
for this.=20

Regards,

Yogesh -

As you've already discovered, the Text datatype is not supported in
SQLNS for the reasons that Andy mentioned.

As a workaround, can you send a notification to the remote server that
indicates that it should connect to your instance and pull the text
field across?

There may also be some other/better ways to do this; perhaps DTS, etc?

--
Joe Webb
SQL Server MVP


~~~
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, 31 Aug 2005 08:02:53 -0700, Yogesh Kadalgikar
[quoted text, click to view]