SQL Server 2000 Support

“Microsoft recognizes Altova's XMLSpy Suite [now the Altova MissionKit] as an industry leading XML development tool, and we are pleased to have authoring support for SQLXML directly within XMLSpy Suite," said Stan Sorensen, Director of SQL Server Product Marketing at Microsoft Corporation. "Using XMLSpy's powerful graphical schema editor, software developers and database administrators can easily create and edit XML schemas, which simplify programming and data management.”

SQL Server 2000 provides extensive database programming capabilities built on Web standards. Rich XML and Internet standard support give you the ability to easily store and retrieve data in XML format with built-in stored procedures. You can also use XML updategrams to insert, update and delete data. With SQL Server 2000, you can use HTTP to send queries to the database, perform full-text searches on documents stored in database, and run queries over the Web with natural language.

SQL Server 2000 analysis services capabilities are extended to the Internet. You can access and manipulate cube data by means of a Web browser.

SQLXML 3.0 adds support for XSD mapping schemas, client-side XML functionality, a new SQLXML OLEDB provider, a tool to convert XDR mapping schemas to XSD, and significant performance improvements. SQL Server 2000 users can use client-side XML functionality to move XML processing to the middle tier for better scalability or to wrap SQL Server stored procedures with the Transact-SQL FOR XML clause.