After you apply post-Microsoft SQL Server 2000 Service Pack 3 (SP3) hotfix build versions between 8.00.0859 and 8.00.0875, applications that execute a stored procedure that uses a SET NOCOUNT ON statement and that return one or more result sets following an informational message, a RAISERROR stateme
Other News
Oracle Tip: The end of rule-based optimization in Oracle 10g
More than a decade ago, all Oracle databases used what is now called rule-based optimization, which uses a fixed strategy to optimize a query’s results. (R)
Replication setup for DB2 Universal Database
(Mika Nikolopoulou) Replication is one way to make your data available where and when you need it. This article explains what replication can do for you, and shows you how to set it up, step by step, using an example from an actual customer site. The author includes hints and tips along the way to h
The ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL Server 2000
When you use the ORDER BY clause in a view, an inline function, a derived table, or a subquery, you must also specify a Top operator. If you try to use an ORDER BY clause and you do not specify a Top operator, the following error may be returned to the client: Server: Msg 1033, Level 15, State 1
WWW2004 Semantic Web Roundup
(Paul Ford) According to Tim Berners-Lee’s WWW2004 keynote address, the Semantic Web is entering “phase II”, a time of “less constraint” when Semantic Web developers are encouraged to build upon the foundations of RDF and OWL to create working applications on both the server and the desktop. And whi
Auditing Your SQL Server Part 4 – Selective Auditing
(Steve Jones) Auditing is always a double edged sword. When you need to determine what happened, you want all the information that you can possibly have. However when you don’t have issues, you have this huge volume of information to wade through, most of which doesn’t really make sense. Balanci
Vulnerabilities found in E-Business Suite 11i
(Robert Westervelt) Multiple SQL injection vulnerabilities have been discovered in the Oracle E-Business Suite 11i and Oracle Applications 11.0 that could allow an attacker to take control of the database and applications. (R)
.NET tools for working with XML
(Peter G. Aitken) A lot of people associate the .NET framework with XML, and for good reason. .NET uses XML behind the scenes to implement many of its development tools, such as SOAP and Web services. Beyond that, however, .NET provides a powerful set of classes for working with XML directly. Whatev
Installation viewlets: Content Manager V8.2
(Michael A. Ahern) The downloadable files available here are screen captures of DB2 Content Manager version 8.2 installations presented as Viewlets. Demonstrations include Viewlets of installing (AIX and Windows platforms unless otherwise noted) DB2 Enterprise Server Edition version 8.1, WebSphe
Oracle’s explain plan
Whenever you read or write data in Oracle, you do so by issuing an SQL Statement. One of Oracle’s task when it receives such a statement is to build a statement execution plan. An execution plan defines how Oracle finds or writes the data. For example, an important decision that Oracle has to take i