Hi, I am addressing to all the gurus of SQL Server 2000.
I have a problem and that is smashing me to be go ahead.
The problem is that when i try to copy a large data in which some kind of HTML is present into the TEXT field of the SQL Server 2000 table,that is truncated and i could not be able to store the complete data to there. Also i am unable to view the TEXT field when i get the records of the table.
Any thoughts about it . I know the TEXT field can store millions of characters, but in my String there are only near about 7500 characters.
 I tried to copy the query to query analyzer and run that, that shows me , query run successfully, but does not enter the complete data.

Query is given below:

UPDATE tbltext SET pgText = '<table width="564">
    <tbody>
        <tr>
            <td>  </td>
        </tr>
        <tr class="txt">
            <td width="564">
            <h2 class="title">Which loan is right for me?</h2>
            </td>
        </tr>
        <tr>
            <td valign="top">
            <table cellspacing="2" cellpadding="4" width="100%" border="0">
                <tbody>
                    <tr class="oddrow">
                        <th>Years you plan to stay in the home</th>
                        <th>Recommended program</th>
                    </tr>
                    <tr class="evenrow">
                        <td>1-3 years</td>
                        <td>3/1 ARM, 1 year ARM or 6 month ARM</td>
                    </tr>
                    <tr class="evenrow">
                        <td>3-5 years</td>
                        <td>5/1 ARM</td>
                    </tr>
                    <tr class="evenrow">
                        <td>5-7 years</td>
                        <td>7/1 ARM</td>
                    </tr>
                    <tr class="evenrow">
                        <td>7-10 years</td>
                        <td>10/1 ARM, 30 year fixed or 15 year fixed</td>
                    </tr>
                    <tr class="evenrow">
                        <td>10+ years</td>
                        <td>30 year fixed or 15 year fixed</td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
        <tr>
            <td valign="top">
            <table cellspacing="2" cellpadding="4" width="100%" border="0">
                <tbody>
                    <tr>
                        <th>Loan Program</th>
                        <th>Advantages</th>
                        <th>Disadvantages</th>
                    </tr>
                    <tr class="oddrow" valign="top">
                        <td><strong>Fixed Rate Mortgages</strong>
                        <ul class="condensed">
                            <li>30 year fixed </li>
                            <li>15 year fixed </li>
                        </ul>
                        </td>
                        <td>
                        <ul class="condensed">
                            <li>Monthly payments are fixed over the life of the loan </li>
                            <li>Interest rate does not change </li>
                            <li>Protected if rates go up </li>
                            <li>Can refinance if rates go down </li>
                        </ul>
                        </td>
                        <td>
                        <ul class="condensed">
                            <li>Higher interest rate </li>
                            <li>Higher mortgage payments </li>
                            <li>Rate does not drop if interest rates improve </li>
                        </ul>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="4"><br /></td>
                    </tr>
                    <tr>
                        <th>Loan Program</th>
                        <th>Advantages</th>
                        <th>Disadvantages</th>
                    </tr>
                    <tr class="oddrow" valign="top">
                        <td><strong>Adjustable Rate Mortgages (ARM)</strong>
                        <ul class="condensed">
                            <li>10/1 ARM </li>
                            <li>7/1 ARM </li>
                            <li>5/1 ARM </li>
                            <li>3/1 ARM </li>
                            <li>1 year ARM </li>
                            <li><nobr>6 month ARM</nobr> </li>
                            <li>1 month ARM </li>
                        </ul>
                        </td>
                        <td>
                        <ul class="condensed">
                            <li>Lower initial monthly payment </li>
                            <li>Rates and payments may go down if rates improve </li>
                            <li>May qualify for higher loan amounts </li>
                            <li>30 year term, no balloon payment </li>
                        </ul>
                        </td>
                        <td> </td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
    </tbody>
</table>' WHERE pgId = 3

I am waiting for some GURU response.
Plz help me out GURU

Regards,