Hi Everyone,

I'm running a delete statement to remove millions of records in a table on a live environment in full recovery mode.
Because of the amount of transactions the delete is sure to create, I decided to run the operation in batches of 250000 records each. In order to control the size of the transaction log, I've also scheduled a job to backup the t-logs every 2 minutes.
The problem I've noticed is that after deleting...

You can use the following function to remove all namespaces

static XElement stripNS(XElemen t root)
{
return new XElement(
root.Name.Local Name,
root.HasElement s ?
root.Elements() .Select(el => stripNS(el)) :
(object)root.Va lue
);
}

Hi Zmbd,

I've formatted the code as requested.

many thanks.

Hi All,

I need to remove all namespaces from xml file shown after c sharp code (also been attached).
The problem is that I am getting the following error being returned by one of the functions

{System.Xml.Xml Exception: The prefix '' cannot be redefined from '' to 'http://sample.response .power.core.com ' within the same start element tag.
at System.Xml.XmlW ellFormedWriter .PushNamespaceE xplicit(String...