When you try to install a Microsoft SQL Server 2000 service pack, the installation may fail, and you receive the following error message: This Service Pack is meant for a different language than your installed product
Other News
Examining Organizational Workflows under the hood of .NET
(razi_rais) Being a software practitioner and also a hardcore .net developer there are numerous amounts of times in the recent years I come across the need of building a Workflow. Almost every single corporate organization in this world use computer automation in one way or another, and when we tal
An Intro to CLR Integration in SQL Server 2005
(Sahil Malik) T-SQL has been the conventional method of writing database objects such as stored procedures, triggers, aggregates, and so forth. SQL Server 2005 introduces a new array of possibilities because of its tight integration with the .NET Framework. It allows you to write stored procedur
TechTip: Optimize Your SQL Procedures, Triggers, and Functions
(Kent Milligan) When an SQL procedure, trigger, or function is created, DB2 UDB for iSeries generates a C program object with embedded SQL to implement the business logic described in the procedural SQL object. This C program implementation is transparent to the programmer because DB2 UDB takes care
Safeguarding your data in MySQL
(James F. Koopmann) This week I am going to look at a tool called EMS MySQL Manager put out by EMS. You know I haven’t backed up my MySQL database since I installed my Bugzilla tracking system. Thought this might be a great place to get a backup as MySQL Manager has backup and restore functionality
Cloudscape Version 10: A technical overview
(Kathy Saunders and Jean Anderson) The core of IBM Cloudscape is the Apache Derby open source database. Derby’s lightweight, embeddable architecture makes it the ideal database engine for deploying database-driven Java applications. With Derby, the database engine becomes part of the application, so
Using SQL datetime and smalldatetime values inside XQuery
(Mike Rorke) I had a request today asking me how to get the current date/time as part of an XQuery expression in SQL Server 2005. The XQuery standard defines various functions to do this type of action, but unfortunately, SQL Server 2005 XQuery does not support these 🙂 Rather, you need to get the d
Model-driven XML forms generation, Part 1: Start using the XML Forms Generator
(Jan J. Kratky, Kevin E. Kelly, Steve Speicher and Keith Wells) Find out how the XML Forms Generator utilizes Model Driven Development concepts with the Eclipse Modeling Framework to permit generation of forms from XML instance data. The XML Forms Generator, which is available from IBM alphaWork
Using Data Transformation Services: Package Execution Using SQL Server Agent, Introduction
(Jayaram Krishnaswamy) The scenario is one of creating a DTS package that populates a table in an MS Access database from an SQL Server database on a schedule. The scheduling is to be carried out by creating an SQL Job. MS Access is often used for creating reports, and this scheduling makes it e
Altova unveils royalty-free XML engine
(Ed Tittel) I’m taking a break in my XSLT tutorial coverage for this XML tip, because I’m away from my office, visiting family in south Florida. With one eye out for hurricanes, and another on my 18-month-old son, I hope I can be forgiven for this brief hiatus in my planned coverage. The XSLT tu