Basics

SQLXML 3.0 Beta

• by Brian Knight

• SQLServerCentral.com

• Topic

Comments posted to this topic are about the content posted at http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/824/msdncompositedoc.xml

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-12-30

6 reads

Simple OLE DB Provider for XML

• by Additional Articles

• ASPToday

• Miscellaneous

• Article

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.

2001-12-10

1,479 reads

• Discuss

Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server

• by Kunal Das

• SQLServerCentral.com

• Basics

• Article

This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-11-29

3,558 reads

• Discuss

SQL7 install problems on new Win2k box

• by mhenriks

• It Toolbox

• Topic

I am installing a copy of SQL 7 on one of our 2000 boxes and it is failing when the service is restarting. I am using a local admin account for both SQL/Agent services. Stopping Service ... Starting Service ... An error occurred while attempting to start the service (1460) SQL Server configuration failed. Any […]

2001-11-28

7 reads

Creating script to grant permissions

• by Gert-de-Swardt

• Other

• Topic

Hi I would like to know if there is a way to create a script of all the current permissions for the groups on a database. What I need it for is that all the groups are dropped on a certain database and the all the groups are recreated and there users added. I need […]

2001-11-19

2 reads

Need help writing a stored procedure

• by percivalbrag

• MSDN Communities

• Topic

I am fairly new to SQL Server. I am trying to write a stored procedure to update fields in a table with information in another table. Both tables have a common key field. I have not been able to get this to work. Any help would be graetly appreciated. Percival Bragg

2001-11-02

2 reads

When's Your Anniversary

• by Steve Jones

• SQLServerCentral.com

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/anniversary.asp

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-11-02

4 reads

XML for SQL Server 2000: Optimizing Your Performance

• by Additional Articles

• Microsoft SQL Home

• Basics

• Article

The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.

2001-11-01

2,241 reads

• Discuss

SQLXML 2.0 (XML for SQL Server 2000)

• by Additional Articles

• Microsoft MSDN

• News
• Uncategorized

• Article

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.

2001-10-29

6,623 reads

• Discuss

Multiphase Data Pump

• by Steve-Johnson

• SQLServerCentral.com

• Topic

Can you write back to the Source data using the multiphase data pump?? I have a flag field that is set to "true", after succussfully inserting the record I want to set the flag to "false". Not sure if this is where I should be looking but none the less it looks interesting to learn […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-10-25