/* Test data */
IF OBJECT_ID('tempdb..#Temp') IS NOT NULL
DROP TABLE #Temp

CREATE TABLE #temp (id INT,xmldoc NTEXT)
INSERT  INTO #temp
VALUES
        (1,'<parent><child1></child1></parent>')
INSERT  INTO #temp
VALUES
        (2,'<parent><child>')
INSERT  INTO #temp
VALUES
        (3,'<parent><child2></child2></parent>')
        

/* Process data */
        
SET NOCOUNT ON

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
DROP TABLE #TempTable

CREATE TABLE #TempTable (
    [id] INT NOT NULL,
    [xmldoc] NVARCHAR(4000) NULL,
    PRIMARY KEY (ID))

DECLARE 
    @idoc INT
   ,@rootnode NVARCHAR(255)
   ,@ID INT
   ,@strXML NVARCHAR(4000)
   ,@errMsg NVARCHAR(255)

SET @rootnode = '/parent'

DECLARE ValidateXML CURSOR
FOR
    SELECT
        id
       ,xmldoc
    FROM
        #temp
    
OPEN ValidateXML
FETCH NEXT FROM ValidateXML INTO
     @ID
    ,@strXML

WHILE @@FETCH_STATUS = 0 
    BEGIN

        /* Optional but recommended to remove excess spaces and tabs.             */
        /* However, this may slow down the process considerably so use with care. */
        SET @strXML = dbo.svfRemoveExcessSpacesFromXML(@strXML)    
        
        BEGIN TRY

            EXEC sp_xml_preparedocument @idoc OUTPUT, @strXML

            INSERT INTO #TempTable
            SELECT
                id
               ,xmldoc
            FROM
                #temp
            WHERE
                ID = @ID
                AND CONVERT(XML,CONVERT(NVARCHAR(MAX),@strXML)).exist('(/parent)') = 1

        END TRY
        BEGIN CATCH
            
            SELECT @errMsg = ERROR_MESSAGE()  

            /* Comment out this insert to just skip rows with invalid XML */

            INSERT INTO #TempTable
            SELECT 
                @ID AS id
                ,'Invalid XML: '+@errMsg AS xmldoc            
            
        END CATCH

        SET @strXML = NULL
        
        FETCH NEXT FROM ValidateXML INTO
             @ID
            ,@strXML

    END

CLOSE ValidateXML
DEALLOCATE ValidateXML

SELECT
    id
   ,xmldoc
FROM
    #TempTable

id	xmldoc
1	<parent><child1></child1></parent>
2	Invalid XML: The error description is 'The following tags were not closed: parent, child.'.
3	<parent><child2></child2></parent>

CREATE FUNCTION dbo.svfRemoveExcessSpacesFromXML
    (
     @strXML NVARCHAR(MAX)
    )
RETURNS NVARCHAR(MAX)
BEGIN

    DECLARE 
         @str NVARCHAR(MAX)
        ,@xml XML
        
    SET @str = @strXML
    SET @str = REPLACE(@str,CHAR(9),'    ')        -- convert tabs to spaces

    SET @str = 
    REPLACE(
            REPLACE(
                REPLACE(
                    @str
                ,'  ',' '+CHAR(7))
            ,CHAR(7)+' ','')
        ,CHAR(7),'')
        
    SET @str = REPLACE(@str,'> <','><')

    RETURN @str
    
    /*
    
    SELECT dbo.svfRemoveExcessSpacesFromXML('        hi this	xxxx	 is test                 for onr      jh1 lljkl l l jl   l ')
    SELECT dbo.svfRemoveExcessSpacesFromXML('<soapenv:Body>			<BackgroundReports xmlns="http://www.cpscreen.com/schemas">			  <BackgroundReportPackage type="report">				<ProviderReferenceId>WPS-6308077</ProviderReferenceId>				<PackageInformation>				  <ClientReferences />')
	    
    */

END