If you’ve applied SQL Server 2000 SP3 only to find you’ve lost features that are dependant on xp_cmdshell extended stored procedure, the cause might be a change in the way that authorization for using xp_cmdshell works after the service pack is applied. Join Andrew Novick as he explains how to fix i
Other News
IBM, Oracle Detail Pending App Servers
By Amy Newman – The application server market is an ever-evolving and highly competitive space. Vendors, particularly the high-profile ones, are forever scrambling to gain — and keep — market share.With new releases of WebSphere and Oracle Application Server slated to come out in the next
Find who is executing what command using DECODE
By Murali Krishna B – DECODE is a very powerful tool that can make SQL very efficient or very dense and nonintutive. Using the example below, you can easily track which user is doing what.
The State of XML and Databases in Web Services
By Brian Reed – Web Services applications — like all applications — require easy, consistent, reliable access to data. While some may have a utopian view — where all Web Services applications’ data would reside in XML — the reality is that trillions of bytes of corporate data are stored in exist
I’m Locked Out of SQL Server. How Do I Get Back In?
Q. I locked myself out of SQL Server without being able to log on with a sysadmin login. Can I fix this, or do I need to reinstall SQL Server? A. You don’t have to reinstall SQL Server. To access SQL Server, you need to use the registry key for SQL Server 2000 and SQL Server 7.0 that determin
Developing Web Services: Handling Problems Along the Way
Once developers recognize certain design issues and patterns, the first barrier to Web services development is conquered. In this second article in a five-part series, we cut through another barrier with common sense guidance to help developers gain proficiency quickly and avoid the most common prob
Is There an (X)Doc in the House?
XDocs will likely breathe new life into Microsoft Office and reshape the notion of a document, says XML expert Kurt Cagle. Read on as he explains some of the capabilities of this upcoming application, as well as some of his concerns.
XSLT, Browsers, and JavaScript
by Bob DuCharme – Most XSLT processors offer some way to tell them: “here is the source document and here is the stylesheet to use when processing it.” For a command-line XSLT processor, the document and stylesheet are usually two different parameters specified at the command line.Web browse
SQL Critical Update Kit with Resources for Combating the Slammer Worm
Secure installations of Microsoft SQL Server and the Microsoft SQL Server Desktop Engine 2000 (MSDE 2000) against the Slammer worm with these software tools and other resources.
Oracle in a Nutshell
Find out how the authors of this Oracle opus pared down 13,000 pages of documentation to provide users with 80 percent of the useful information in 20 percent of the space. If you’re an Oracle user, you’ll want to check out, Oracle in a Nutshell.