Microsoft has posted two new Knowledge Base articles that clarify how the ODBC driver for SQL Server 2000 and 7.0 returns messages from certain commands and how to create a SQL Server 2000 Blackbox trace.
Tag: sql server
Compaq Announces Leading TPC Benchmarks for SQL Server 2000
Once again Compaq has shown the ability to take industry standard building blocks — servers, storage and interconnect technology — and deliver maximum performance at industry standard price points. The combination of ProLiant servers, Compaq storage systems, ServerNet II interconnect, and Microso
XML for SQL Server 2000 Web Release 1 Beta 2
Microsoft® SQL Server 2000 introduced several features for querying database tables and receiving the results as an XML document. However, as shipped, Microsoft SQL Server 2000 does not allow changes to an XML document as database inserts, updates, and deletes or the loading of large XML files into
The Ultimate Event for Hardcore Server-Side Developers & DBAs!
We've brought together the leading experts in the industry. Speakers like Steve Wynkoop, Hilary Feier, Don Kiely, Terry Weiss, Mark Souza, Craig Utley, Mike Otey, and other Microsoft and third-party speakers. Register online!
SQL 2000 Demo
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. These samples present an overview of new product features including AWE support, new data types, new user-defined and built-in functions as we
XML Q&A
By Rich Rollman, SQL Server Magazine During the past two months, readers' questions have centered on using ADO and XML. This month, let's explore a different area of SQL Server 2000—the ability to store, index, and retrieve XML.
Paying to Play
If Oracle's technical team were half as effective as its marketing team, Microsoft and SQL Server might really be in trouble. But to Microsoft's advantage, Oracle's recent product announcements and its latest million-dollar challenge show that the Oracle marketing department's achiev
SQL Server 2000 Log Shipping
Thursday, February 15, 2001: 10:00 A.M. Pacific time (Greenwich mean time – 8 hours) In this session, we will discuss the new SQL Server Log Shipping feature and the enhancement made to this newly automated feature. We will talk about why it is robust and will also provide some suggestions abou
Error handling in long-running batch jobs
From SQL Team.com Andy Pope, posed a question on handling errors in long running batch jobs. Basically Andy wanted a way to store job log entries in a SQL Server log table that didn't get rolled back if the enclosing transaction failed. I really wasn't much help giving him an answer so
Overlooked Command-Line Utilities
SQL Server ships with an array of powerful graphical management tools, but it also features many lesser-known command-line utilities that let you use Windows NT shell scripts or VBScript to manage SQL Server. Here are my picks for the seven most overlooked SQL Server command-line utilities, all of w