When you try to access a SQL Server 2000 database from an application, you may receive an error message that is similar to the following: Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network docu

Dr. Michael Rys is the Program Manager for the SQL Server Engine Team at Microsoft. In this role, he has responsibility for many of the XML initiatives in Microsoft SQL Server, including the XQuery support in the upcoming SQL Server 2005, codenamed “Yukon”; Microsoft’s server-side SQLXML technology;

In SQL Server 2000, differential backups may not contain Page Free Space (PFS) pages if the following conditions are true: • The PFS page was allocated between the last full backup and the differential backup. • The PFS page allocation was part of a file growth that is larger than 64 MB.

(Gil Lapid Shafriri and Debra Dove) Gain a better understanding of how to develop your SQL Server Mobile applications to handle multi-user access and data synchronization with Microsoft SQL Server 2005.

(Jeff Hadfield) Tom Rizzo, the director of product management for Microsoft SQL Server, talks about Reporting Services, SQL Server 2005, and more.

(Surajit Chaudhuri, Kris Ganjam, Venky Ganti, Vivek Narasayya, and Theodore Vassilakis) This paper describes the Fuzzy Lookup transformation and Fuzzy Grouping transformation in Data Transformation Services (DTS) for SQL Server 2005. Fuzzy Grouping transformations are useful for improving data quali

(Doug Thews) One of the most anticipated features in SQL Server 2005 (code-named Yukon) and Visual Studio .NET 2005 (code-named Whidbey) is the capability to develop stored procedures, user-defined functions (UDFs), and user-defined data types in .NET 2.0. SQL Server 2005 now supports developing UDF

(Jeremy Kadlec) Due to nature of the existing SQL Server 2000 database in my company, I have to use around four or more tables in my query to get the required results. Consider two tables for now: contracts and dealers. I have to join these two tables in mostly all reports. Indexes have been defined

(Marcin Policht) In this article, we will conclude our coverage of security related changes in SQL Server 2005 Beta 2 (although we will continue discussion of improvements in other functionality areas throughout the reminder of this series). The topics we will focus on here are code and module signi

(Andrew Novick) The current theme is about application trace messages. The previous two articles (Part I and Part II) described the AppSession and the AppSessionTrace tables and the stored procedures that insert and update their rows.