sql server notification services: XSLT formatting and XSD references -- sql server notification services

XSLT formatting and XSD references

shauldar NO[at]SPAM gmail.com
7/9/2006 12:00:00 AM

sql server notification services:

Hi,

I have 2 questions on XSLT formatting:

1=2E I want to refer to an XSD schema, for example to perform parameter
substitutions. From what I saw the schema has to be listed fully as
part of the <NotificationClass> in the ADF.xml file. Is there a way
instead to list an external XSD file name, much like we refer to the
XSLT file name?

2=2E When using SMTP the email arrived garbled, as though the HTML is not
parsed. Am I using incorrect encoding or what? E.g.

<html>
<body>
Report for Seattle [2/21/2005 1:00:00 PM]: Sunny 
Expected low temperature : 3131
F=E2=B8=AE=E3=B0=80=E6=88=80=E7=88=80=E3=B8=80=E0=B4=80=E0=A8=80=E0=A4=80...

Thanks,

-- Shaul

Dr. Shaul Dar
Chief Architecture Officer
Medcon Ltd., a McKesson Company
Tel (within US): 1-866-6549632 (ext. 335)
Tel (International): +972-3-6487702 (ext. 335)
Email: shauld@medcon.com

Re: XSLT formatting and XSD references

Joe Webb
7/13/2006 12:00:00 AM

Hi Shaul -

For question #1 - Not that I'm aware of, but I must admit I've never
attempted to do it. Perhaps someone else can chime in here.

For question #2 - are you using the following Protocol node in your
ADF file?
<Field>
<FieldName>BodyFormat</FieldName>
<SqlExpression>'html'</SqlExpression>
</Field>

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)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.