(Paul Whitaker) SQL Server 2000 Reporting Services offers a robust report parameter interface that is exposed through the report designer, its Web service interface, the report manager, and via scheduled reports. The fact that this interface supports dynamic default parameters is essential to pr

(Sérgio Fontes) In this series of articles I want to analyze and describe database and query development for web solutions, as development technology we will use SQL and Microsoft SQL Server 2000 as the database engine. After making a small trip on the SQL basics we are ready to take a look on T-SQL

(Douglas Reilly) Bob Beauchemin is a developer who not only writes code and develops databases, but also teaches other developers to create applications and databases, often using the latest Microsoft technologies.

(Arthur Fuller) A common problem in writing stored procedures arises when you need to insert one record into table T1 and one or more records into table T2, with the latter containing the PK of the row you just added to T1. Typically, this situation arises when you’re doing batch inserts into a pare

(William Pearson) In this session, we will examine the satisfaction of a business requirement within the cube upon which a pre-existing report is based (we will modify a sample OLAP report to save time and maintain the focus of the lesson as much as possible). We will then add the same capability at

(Klaus Salchner) In today’s enterprises different types of data is sitting in various data stores. Relational data is most likely in a SQL Server database or Oracle database. And many enterprise applications have its own database with its own data and data model. User and account information resides

(Ashvini Sharma) InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This article describes how to work around these potential problems. Th

This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.

(Adam Machanic) It all started so innocently. The MegaWare marketing department wanted a new Web site to post documents on, and the development team thought that using the SQL Server 2000 database as the document repository would simplify things. Steve, MegaWare’s DBA, didn’t see any major issue

When a client application such as Sqlagent.exe tries to connect to a local computer that is running Microsoft SQL Server 2000, a memory leak in the client process may occur. This problem occurs when the client process uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0.