Showing posts with label regards. Show all posts
Showing posts with label regards. Show all posts

Wednesday, March 7, 2012

Operating system question

Hello
Can I install SQL Server 2000 on Windows 2003 Server Enterprise?
--
Best Regards
Wojciech ZnanieckiTake a look here:
http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Wojtek Z" <wojtas_z@.poczta.fm> schrieb im Newsbeitrag
news:d3vqvl$qqf$1@.nemesis.news.tpi.pl...
> Hello
> Can I install SQL Server 2000 on Windows 2003 Server Enterprise?
> --
> Best Regards
> Wojciech Znaniecki
>|||Hi
Yes, just make sure that you apply SP3a after the installation otherwise SQL
Server will not work on that platform.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wojtek Z" <wojtas_z@.poczta.fm> wrote in message
news:d3vqvl$qqf$1@.nemesis.news.tpi.pl...
> Hello
> Can I install SQL Server 2000 on Windows 2003 Server Enterprise?
> --
> Best Regards
> Wojciech Znaniecki
>

Saturday, February 25, 2012

openxml vs xquery behind the scenes ?

Also, with regards the changes from Sql 2000 to Sql 2005.

When dealing with parsing/querying xml within a stored procedure, what is the difference (internally to sql server) between using OPENXML and xquery statements within a stored procedure ? With openxml, you need to call sp_xml_preparedocument, which will load a special version of the msxml parser called msxmlsql and loads the entire document into memory.

One thing that I like about XQUERY is that you can use the CROSS APPLY join to process database XML data on a row by row basis. I am new to using XML so I am also interested in hering the answer.