When you try to send an e-mail message by using the xp_sendmail extended stored procedure on a computer that is running Microsoft SQL Server 2000 Service Pack 2 (SP2) or later, the xp_sendmail extended stored procedure may not run successfully. You may receive the following error message: Serve
Other News
Find How Many Times a Day Appears
(Srinivas Kasam) This example shows how to find how many times a day of the week comes between two dates.
A Visual Tour of SQL Server Yukon – XQuery Editor
(Suhil Srinivas) This article is the second in a series of articles giving developers a visual tour of Yukon. The previous article was aimed at giving a developer a tour of the SQL Workbench. In this article the primary focus would be on the XQuery designer.
T-SQL Back Doors
(Itzik Ben-Gan) As with any software, SQL Server contains many back doors and other undocumented features that programmers use. Using only documented and supported features has many benefits: Your code is less prone to failures, you can more smoothly upgrade to newer SQL Server releases, porting you
Architects Of Change
(Kim Moutsos) After three years under construction – and a year of pre-ship buzz – DB2 UDB for z/OS v.8 is ready for the big “reveal.” DB2 Magazine talks to the product’s lead architect for a preview of the changes.
DB2 and Dynamic Logical Partitioning
(Punit Shah) This article discusses the dynamic behavior of DB2 v8.1 and when AIX 5L memory and CPU resources change, and how changes in a few DBM and DB configuration parameters are handled using a Dynamic Reconfiguration script (DR script).
Tutorial 6: Using Stored Procedures
A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedures reduce network
Cross-Platform DB2 Stored Procedures: Building and Debugging
(Maria Almeida) This IBM Redbook documents a residency project conducted at the IBM International Technical Support Organization, San Jose Center. The project tested and implemented stored procedures executing in DB2 for OS/390, DB2 for Windows NT, DB2 UDB for AIX, and DB2 for AS/400 servers. Thi
Community Integration and XML – Extending integration between trading communities
(Scott Simmons) Community integration elevates collaborative commerce to a new level of integration between enterprises. XML-based document exchanges between companies impose new challenges on organizations building a B2B community integration solution.
Facing Forward with JSF
(Budi Kurniawan) JavaServer Faces (JSF) is a new technology for rapidly building Web applications using Java technologies. JSF expedites the development process by providing the following features: standard and extensible user interface (UI) components, easily configurable page navigation, component