If a stored procedure exits with the @@trancount value that is not the same as when the stored procedure was entered, the following error will occur: Error: 266, Severity: 16, State: 1 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = %ld, Cu
Other News
MySQL Grows Its Network
(Sean Michael Kerner) MySQL AB is continuing its march up the enterprise stack with a new subscription-based offering announced today at the LinuxWorld show in Boston. The open source database vendor also unveiled a certified partner program for the new MySQL Network at the event.
Migrating HTML to DITA, Part 2: Extend the migration for more robust results
(Robert D. Anderson) The Darwin Information Typing Architecture (DITA) holds many advantages over information authored directly in HTML, including better reuse, easily changed presentation styles, and easy single sourcing. In Part 2 of this two-part series on how to quickly migrate HTML topics to DI
AppSettings In web.config
(Scott) ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.
.NET Remoting: Handling Remote Server Events
(Paul Kimmel) This article provides a no-frills demonstration of raising and handling remote server events using Microsoft’s .NET Remoting, while guiding you through potential traps and errors.
FIX: The setting for the precision and the scale of the data that is returned from a stored procedure output parameter is (38,0) when a null value is returned in SQL Server 2000
Assume the following scenario: In Microsoft SQL Server 2000, a stored procedure output parameter uses a decimal data type or a numeric data type. When a null value is returned, the setting for the precision and the scale of the data that is returned from the stored procedure output parameter is (38,
SQL Server 2005 Data Mining
(Raman Iyer and Jesper Lind) The concept of cross-sell is familiar to most of us. What your friendly neighborhood McDonald’s salesperson does when you order a cheeseburger is exactly what Amazon.com or buy.com are doing online when you add items to your shopping cart and you get a list of other item
Data Access Application Block
This page provides an overview of the Enterprise Library Data Access Application Block. This is reusable and extensible source code-based guidance that simplifies development of common data access functionality in .NET-based applications.
IBM ICES Competition with Record-Breaking Linux Database Performance; DB2 ICE Delivers Top Cluster Performance for the Price of a Single System
IBM today set a new standard for Linux database performance with the announcement of a record-shattering 1 Terabyte (TB) TPC-H benchmark using the IBM DB2 Integrated Cluster Environment (DB2 ICE). This is the first time that a large data cluster delivered record-breaking performance at a price point
Digital Evolution Creates First XML VPN For .NET Web Services
Digital Evolution, a leading provider of SOA and Web services management and security software, today announced the release of the industry’s first business-to-business Web services security solution for .NET Web services.