In Microsoft SQL Server Management Studio, you receive the following error message when you try to open Microsoft SQL Server 2000 Data Transformation Services (DTS) packages: SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, “SQL Server 2
Other News
Open Source Database Special Feature: An Introduction to Berkeley DB XML
(Selim Mimaroglu) In this article I am going to introduce you to the latest version of the Berkeley DB XML, version 2.2.8. Berkeley DB XML (BDB XML) is built on top of the well-known Berkeley Database (BDB). BDB XML is an open source, native XML database. Like its ancestor, BDB, it’s an embedded dat
Improving concurrency by knowing your application (Part 3)
(Chris Eaton) This posting is a follow-up to the comments made on my last posting. Enrique Valdez asked if it was possible to change the lock wait behavior for a given application from within the application itself. For example, would it be possible for a given transaction to never wait for a lock w
Oracle Forms 10g – Dynamic LOVs
(François Degrelle) The solution described in this paper enables Oracle Forms developers to centrally manage List of Values (LOV). Changing a LOV in a Forms module doesn’t require to open the module or to re-compile it. (pdf)
Oracle Tops Off ID Management Suite
(Clint Boulton) Fresh off of the integration of its purchases of OctetString and Thor Technologies, Oracle released the Oracle Identity and Access Management Suite to help corporations address security concerns.
Backup your SQL Server Analytical Database – Part II
(Muthusamy Anantha Kumar) Part I of this article provided general guidelines on how to backup a SQL Server 2000 Analytical database manually. Part 2 examines how to automate this backup process of Analytical databases from various servers.
10 common SQL Server problems and solutions
This handy two-page list outlines 10 familiar SQL Server problems and an assortment of solutions. From “Out of Space” errors to a database going suspect, this list is great quick reference for every SQL administrator. (pdf)
.NET and Java: A Study in Interoperability
(Ted Neward) In the halcyon days of my youth, a major candy manufacturer ran an advertising campaign. It was destined to be a timeless classic, one that sticks with you for the rest of your life: a scene would be some typical meeting place (like a park or a street), one actor would walk from one en
Complex data binding expressions in ASP.NET
(Fritz Onion) I often find when using templated data-bound controls (in either ASP.NET 1.1 or 2.0) that my expressions become rather difficult to understand because of the need to fit all of your logic into a single expression.
DB2 and Rational: Working together, Part 1: Introduction to DB2 development with Rational Application Developer
(Debra R. Eaton) The IBM DB2 Universal Database (UDB) plug-ins for Rational Application Developer give developers the ability to connect, browse and alter DB2 databases. In this tutorial learn how the Rational Application Development perspectives, views and wizards assist you with defining and worki