Articles

SQLServerCentral.com Launches its New Contest!

Is your budget tight this year? Be the user who enriches the SQL Server community the most and receive the top prize of a full version of Lumigent's Log Explorer (a $995 value!). You could also win an Apress prize pack or a T-SQL Solutions subscription. Any SQLServerCentral.com user who helps to build the SQL Server community by submitting a script, posting in the forum or posting an original FAQ is eligible.

2002-02-01

6 reads

BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information.

2002-01-28

1,740 reads

How to Setup Log Shipping with SQL 2000

This white paper outlines the following:

-The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition.

-The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition.

-A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.

2002-01-25

1,822 reads

XML Data Solutions

This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

2002-01-18

2,982 reads

Blogs

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

Why aren't the backups working?

By Rod at work

You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...

Cannot insert duplicate key in object

By adonetok

In table tUSERI primary key was added in the column [Email]. I deleted a...

Random excessive CPU consumption

By DataGuy

Hi all. I'm in a bit of a quandary with one of our Analysis...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers