Companies and users of SQL Server 2000 Windows® CE Edition (SQL Server CE) that have upgraded SQL Server 2000 database and publisher servers to the Service Pack 1 (SP1) release should also update the server replication components on Internet Information Services (IIS) servers.

This extended stored procedure will generate crosstab results from standard SQL statements. You now do not have to run OLAP services to generate what Microsoft Access has been able to do for years. See the Online instructions for an example of what xp_ags_crosstab can do.

By Edward Myers – Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about a

Microsoft® SQL Server View Mapper enables you to produce an XML View schema file that relates an XDR schema to a SQL Server schema. Using this tool and the documentation requires a working knowledge of both XML and database concepts and terminology.

OmniAudit allows you to automatically and transparently track changes to any column of any table in your Microsoft SQL Server 7.0 or 2000 databases. Not only capture before and after values for each changed column, but also identify the user making the change, the date and time they changed it, the

by Alexander Chigrik – In this article, I want to tell you about the undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and most are stored in the master database (only the sysfiles1, sysproperties and sysfulltextnotify system tables are s

Robin Dewson is the author of the Wrox Press book, Beginning SQL Server 2000 Programming, and the co-writer of several other SQL Server-related books, including Professional Access 2000 Programming, Professional SQL Server Development with Access 2000, Professional SQL Server DTS, and Professional S

By Barbara Darrow – Microsoft and Merant DataDirect teamed on a driver to allow integrators to pump data back and forth between Windows-centric SQL Server and Java applications.

Extensible markup language (XML) is a meta-markup language that provides a format for describing structured data. Unlike hyper text markup language (HTML), XML does not handle the presentation of data. Instead, the tags used to encompass the data are used to describe the data. This allows for a simp

From SQLTeam – I’ve seen a few posts asking “How do I ftp a file into SQL” Well, if you have 6.5 or 7.0 this article should be helpful. Unfortunately it’s not an easy answer, but it’ll work great once you’ve set it up. The answer is that there isn’t a function in SQL to let you do this, you […]