(Chris Kempster) The following article shows, through code, how to enable SQL Agent alerts and using a simple stored procedure and DLL, send emails via an SMTP server rather than using SQL Mail. We will cover these items: SQL Agent Event Alerts SQL Agent Tokens Calling DLL’s via sp_OA method
Other News
XSD Restrictions/Facets
Restrictions are used to control acceptable values for XML elements or attributes. Restrictions on XML elements are called facets.
XML integration with ADO+
(Pawan Bangar) Microsoft designed ADO+ hand in hand with the .NET XML framework. Both are components of a single architecture. The unification of ADO+ with the XML framework happens in the dataset.
‘XML document must have a top level element’ error message when you create a new site or when you synchronize users in Project Server 2003
You may experience one or both the following symptoms in Microsoft Office Project Server 2003: • When you try to create a new site for your project in Microsoft Office Project Web Access 2003, you may receive the following error message: Error occurred when creating site. Site does not seem t
Java User Defined Functions in DB2
(Viswanath Nandigam) We can learn how to implement a DB2 UDF by following an example where we need to do a BIT AND operation on two numbers. IBM DB2 does not support “AND” or “OR” operations. In these cases, we can use Java UDFs to overcome these shortcomings in DB2. (pdf)
Errors Generated if TCP/IP DDM Server on AS/400 Not Started
If the TCP/IP DDM Server on the AS/400 is not started, the following data providers cannot connect over TCP/IP: • Microsoft OLE DB Provider for AS/400 • VSAMMicrosoft OLE DB Provider for DB2Microsoft ODBC Driver for DB2
Client Callbacks in ASP.NET Whidbey
(Saravana Kumar) Client Callbacks is a new feature in ASP.NET Whidbey(2.0). It allows calling server side events asynchronously, without causing postback. It is possible to do asynchronous call using XMLHttp Post in ASP.NET 1.0 itself, but now in ASP.NET 2.0 a clean framework is available to do thi
Instrumenting Applications with .NET Tracing
(Joe Mayo) For many small and medium sized programs, it isn’t too difficult to find and fix bugs based on reproducible information from users. As applications increase in size and complexity, the ability to figure out what is causing a bug becomes more difficult. On larger enterprise systems you nee
Oracle9i Analytic SQL Features, Part 4
(Brad Cowdrey) This article will take an in-depth look at the advanced aggregation features including formatting using the GROUPING function and composite grouping through examples including syntax and behavior. In addition, this article will build on the information and examples from the previo
MSSQL Server 2000 Reporting Services: Reporting Services Basics: Create a Reusable Template Report
(William Pearson) In this article, we will venture away from the functionally specific focuses of recent sessions, and concentrate on a basic consideration that can save us a great deal of time in our work within reporting services. As most of us who have worked with enterprise reporting packages ha