(Muthusamy Anantha Kumar) SQL Server job schedule configuration is limited to a one-time occurrence: daily, monthly and weekly. [Refer Fig 1.0] There are many occasions when you need to run a job on certain dates in a year. Many Finance and pharmaceuticals companies have End of Month processing, End
Other News
FIX: The BULK INSERT statement silently skips insert attempts when the data value is NULL and the column is defined as NOT NULL for INT, SMALLINT, and BIGINT data types in SQL Server 2000
In Microsoft SQL Server 2000, the Transact-SQL BULK INSERT statement silently skips insert attempts when the column is defined as NOT NULL for an INT, SMALLINT, or BIGINT data type.
IBM’s Information Management Battle Cry is Don’t Migrate, Integrate!
This article is a Q&A with Jonathan L. Prial, Vice President, Marketing, Information Software Management Group, IBM.
Why I Don’t Use DataSets in My ASP.NET Applications
(Scott Mitchell) A couple weeks ago I gave a talk to the local San Diego ASP.NET SIG and during my talk I mentioned how I, personally, rarely, if ever, use DataSets in my ASP.NET applications, sticking with the good ol’ DataReader instead. Since then I have received a number of emails from atten
PHP and JavaScript Interaction: Storing Data in the Client, part 1
(Alejandro Gervasio) Modern websites demand heavy interaction between server-side and client-side programming. In the first part of this article series, we will implemented a simple mechanism to make PHP and JavaScript interact, creating a function which can build an array structure and store inform
Open Source Databases Lurk at the Edge
(Joe McKendrick) Open source software has captured the imagination of much of the IT world, and open source databases are very much a part of this equation. However, to a large degree, open source databases have only cracked open the door to the enterprise, and many remain confined to peripheral app
A Hands-on Introduction to BPEL, Part 2: Advanced BPEL
(Matjaz B. Juric) Business Process Execution Language (BPEL) is ideal for definition and execution of business processes that can be relatively simple or very complex. In the first installment of this series, you learned how to develop a relatively simple business process. This article presents more
Explore SQL Server 2000 DTS Packages Using .NET and the DTS Class Library
(Jeffrey Juday) SQL Server developers and administrators are no strangers to Data Transformation Services (DTS) packages. They likely develop DTS packages to perform everything from simple database operations to data aggregation. As such, when they upgrade some or all of their servers to SQL Server
FIX: You may receive a ‘SQL Server could not spawn process_loginread thread’ error message, and a memory leak may occur when you cancel a remote query in SQL Server 2000
When you cancel a remote query that returns many data rows in Microsoft SQL Server 2000, a memory leak may occur. The size of the memory leak depends on the size and the type of data that is being retrieved from the remote server. You may receive an error message that is similar to one of the follow
XVTV — Voice-operated television!
(Marc White and Jeff Paull) For those of you who have always wanted to control your TV using only your voice, you are going to love the XVTV remote control system. With XVTV in your home you can do anything from change channels to program a PVR (Personal Video Recorder) using simple voice commands.