(Matt Newman) In this article I plan to demonstrate how to insert and read data from a SQL Server or MSDE database. This code should work on both SQL Server , I am using 2000, and MSDE. I am using Visual Studio 2002, but this should work with Visual Studio 2003, Web Matrix, and the command line SDK.
Other News
XP SP2 and SQL Server
(Brian Moran) In June, I wrote about the effects that Windows XP Service Pack 2 (SP2) has on SQL Server (see “Windows XP SP2 Defaults Break SQL Server Connections” at http://www.winnetmag.com/article/articleID/42854/42854.html ). Now that XP SP2 is dribbling out through Windows Update and other sour
SQL Server 2000 Security – Part 10 – Auditing
(Marcin Policht) So far, in our series, we have been focusing on tasks geared towards configuration changes, which increased the default security level of the SQL Server 2000 installations. However, no matter how much time and attention you dedicate to this process, it is likely that sooner or later
Protocol Design: Reliablity and Security
(Itamar Shtull-Trauring) Protocols are part of the infrastructure used to implement a service: delivering an email message, requesting a web page. These services have security and reliability requirements that need to be implemented at different layers of the infrastructure. For example, emails
ADS Enables
(Rob Hawthorne) Microsoft’s free server tool, ADS (Automated Deployment Services), provides system administrators with a consistent way to deploy the Windows OS, but what about RDBMS deployment? Does setting up SQL Server on a number of servers mean you have to run setup.exe again and again, specify
Taking High Availability Higher
(Robert Catterall) IBM zSeries servers, otherwise known as mainframe computers, have a reputation as highly available systems — a reputation earned through four decades of rock-solid reliability. DB2 for z/OS is an important part of the zSeries availability story. In this column, I’ll describe so
Finding XML system objects in SQL Server 2005
(Vinod Kumar) Having played with a couple of examples with XML features in Yukon, you might be interested to know where can I find the association of XML Schema’s to the XML Datatype. In this FAQ section we will look at the tables that govern behind the scenes these values. It is to be under
DB2 Interfaces with Microsoft Access
When you use Microsoft Access to interface with a DB2 database, you are given two options for the ODBC connection. The first is to allow a link to the database, and the second is to import a table from DB2. Since you need to use ODBC for Access to talk with DB2, you should install the DB2 Client Ena
Get SQL Server table structure in XML format
(Baya Pavliashvili) Developers often ask me if there is a built-in stored procedure in SQL Server 2000 that returns the table structure in XML format. If the front-end or middle-tier code passes data to the stored procedures in XML format, a table structure similar to the following is useful. (R)
Manually configure the Oracle 10g EM dbconsole
When you choose to create a preconfigured database during the Oracle 10g installation, you can select the Oracle Enterprise Manager (OEM) interface that you want to use to manage the database.