The named pipe cannt be removed in 2000SP3. It can be removed in SP3a or SP2. But it's recommended to keep it. 

Please check with the following link: http://support.microsoft.com/kb/831127/

The following example is taken from http://www.perfectxml.com/Articles/XML/OPENXML.asp

It shows how to handle namespace in OPENXML.

DECLARE @idoc int

DECLARE @doc varchar (1000)

SET @doc ='

<?xml version="1.0" encoding="UTF-8"?>

<bk:Books xmlns:bk="http://www.PerfectXML.com">

<bk:Book bk:ISBN="186100589X">

<bk:Title>XML Application Development with MSXML...

Is the job a tsql job or cmd shell job? For the latter one, if it runs too long time, the job may hang due to os problem.

Yes, you can use fixed size configuration for both instance.

Another way is still using dynamic memory configuration, but set the max memory to 1.3GB for each instance.

You certainly can add a language column in your PK. The problem is that you will have too much redundancy for non-text columns, and it will be difficult to maintain...

When you call sp_xml... in your sp, you need to declare a local variable. However, SQL 2000 does not support local variable with Text or nText data type. So the...

the status 1073741832 means the database was cleanly shut down. When you took a database off line, the status is EM is 'Offline'. After you restart SQL server, the status...

I am using a seperate table to hold all the localized value for each table and  lauguages. The table is something like:

LocaleID, SourceTableName, SourceField, SourcePKValue, Text

e.g.

'en-US',   'dbo.Author', 'Name','5','Rob'

In the stored procedure where localized value...

sp_start_job just starts the job, it does not wait until the job is finished. So if the sub-job is started successfully, the sp returns no error.

It cannot gurantee the...

I once had this problem before. I had two script files, each about 7 MB. One is to create a blank database, one is to upgrade an exsiting database. The first...

If you are going to use the local partitioned view, the partition column must be part of PK. Based on the schema you gave, all your columns in the table are...

The following code can convert all columns into one for any table in the current db. The table should not contain image and timestamp columns. You can easily change the...

I have several SPs that accept nText parameters, which are parsed later by OPENXML.

In my opinion, passing Text/nText parametr is the only practical way to do this. The reason is SQL...

"By the way, there is another nested stored procedure which gets called also."

Sounds to me you are tracing the SP:Starting or SP:Completion event. In this case, all nested SP calls...

I am not sure SP4 has bugs or not in the xml related SPs. In SP3, if your SP decompposing xml is getting slower dramatically, it is probably caused by...