Calling SQLXML From XSLT

(Sorry for the cross-post - I put this on the regular XML list by
accident.)
There there anyway to get this to work:
http://mydomain.com/some.xml&xsl=mother.xslt
where some.xml is
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR xml path('somenode'), root('nodes')
</sql:query>
</root>
and mother.xslt has
<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>
Note that we use windows authentication.
Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspx
Check out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )
|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintrove.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!

Calling SQLXML From XSLT

(Sorry for the cross-post - I put this on the regular XML list by
accident.)
There there anyway to get this to work:
http://mydomain.com/some.xml&xsl=mother.xslt
where some.xml is
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:header sql:nullvalue="IsNULL">
</sql:header>
<sql:query >
SELECT * FROM sometable
FOR xml path('somenode'), root('nodes')
</sql:query>
</root>
and mother.xslt has
<xsl:variable name="employees" select="document('http://mydomain.com/
someother.xml')"/>
Note that we use windows authentication.
Based on these, it appears not to be possible:
http://msdn2.microsoft.com/en-us/library/ms763800.aspx
http://msdn2.microsoft.com/en-us/library/ms256465.aspxCheck out this article:
Communicate with a SQL Database During an XSL Transform
http://www.braintrove.com/article/30
--=20
Greg Collins [Microsoft MVP]
Visit Braintrove ( http://www.braintrove.com )|||On Apr 26, 11:34 am, "Greg Collins [Microsoft MVP]"
<gcollins_AT_msn_DOT_com> wrote:
> Check out this article:
> Communicate with a SQL Database During an XSL Transformhttp://www.braintro
ve.com/article/30
> --
> Greg Collins [Microsoft MVP]
> Visit Braintrove (http://www.braintrove.com)
This a good article, Greg. However, I'm trying to accomplish this
strictly with SQLXML via 1 URL. I pass the master xml doc along with
an xslt doc which itself creates a variable via another SQLXML URL.
Any more ideas about this?
Thanks!

call regular phone number job completes

How can I have a sql agent job call a regular (land line) phone number when the job has completed? Any way to do this?
Thanks!
You could package some kind of DLL that will do this, then call it using
sp_OA* or an EXE from the command line using xp_cmdshell.
http://www.aspfaq.com/
(Reverse address to reply.)
"AshleyT" <anonymous@.discussions.microsoft.com> wrote in message
news:67DCD721-A327-460C-A576-954D2FB24716@.microsoft.com...
> How can I have a sql agent job call a regular (land line) phone number
when the job has completed? Any way to do this?
> Thanks!

call regular phone number job completes

How can I have a sql agent job call a regular (land line) phone number when the job has completed? Any way to do this
Thanks!You could package some kind of DLL that will do this, then call it using
sp_OA* or an EXE from the command line using xp_cmdshell.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"AshleyT" <anonymous@.discussions.microsoft.com> wrote in message
news:67DCD721-A327-460C-A576-954D2FB24716@.microsoft.com...
> How can I have a sql agent job call a regular (land line) phone number
when the job has completed? Any way to do this?
> Thanks!

call regular phone number job completes

How can I have a sql agent job call a regular (land line) phone number when
the job has completed? Any way to do this?
Thanks!You could package some kind of DLL that will do this, then call it using
sp_OA* or an EXE from the command line using xp_cmdshell.
http://www.aspfaq.com/
(Reverse address to reply.)
"AshleyT" <anonymous@.discussions.microsoft.com> wrote in message
news:67DCD721-A327-460C-A576-954D2FB24716@.microsoft.com...
> How can I have a sql agent job call a regular (land line) phone number
when the job has completed? Any way to do this?
> Thanks!