(Peter DeBetta) SQL Server 2000 offers some capabilities for returning XML output via HTTP using SQLXML—and, of course, SQLXML supports Web services creation. Although not rocket science, setting up, configuring, and using Web services in SQL Server 2000 does require a little effort (see the SQLXML

(William Pearson) In this article, we will continue the exploration of distinct counts we began in our previous article, Distinct Count Basics: Two Perspectives. Having discussed why distinct counts are useful, and often required, within the design of robust analysis and reporting applications, we d

When you disconnect from an instance of Microsoft SQL Server 2000 after you submit queries or transactions, error 1203 may be logged in the SQL Server error log. Subsequently, an access violation exception may occur.

(Barrie Sosinsky) A trigger is code that is executed when there is a specific data change in a table. Triggers are one way of controlling how your database responds to INSERTs, DELETEs, and UPDATEs and can be used to maintain data integrity. Triggers are used whenever a constraint placed on data

(Sumit Amar) The stored procedure InsertGenerator generates the INSERT..VALUES statements for the specified table name.

The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: • In SQL Server 2000, after you install the security update that is described in the following Microsoft Knowledge Base article, you may experience an access violation when a high volume of local shared memory connect

(Mike Gunderloy) I don’t do as much developer support as I used to, but I still answer questions on a few mailing lists. Fairly frequently developers seem to lose track of what’s going on when their code calls SQL Server to manipulate data. “I don’t know what’s going on when I do this,” is the typic

(Marcin Policht) Following the discussion of new or enhanced authentication-related functionality in SQL Server 2005 Beta 2 in our previous article, we are shifting our focus to authorization features, which determine the level of access rights once the user’s logon process is successfully completed

This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. (R)

The following issue is fixed in this SQL Server 2000 hotfix package: • In SQL Server 2000, when you send an e-mail message by using the xp_sendmail extended stored procedure, the attached result set column widths are incorrect.