sql server update table
<p>the table:</p>

<pre><code>CREATE TABLE [dbo].[User] (
    [UserName]  NVARCHAR (100) NOT NULL,
    [Pasword]   NVARCHAR (100) NOT NULL,
    [Name]      TEXT           NOT NULL,
    [LastName]  TEXT           NOT NULL,
    [Location]  TEXT           NOT NULL,
    [profesion] TEXT           NOT NULL,
    [Email]     NVARCHAR (50)  NOT NULL,
    [Gender]    TEXT           NOT NULL,
    PRIMARY KEY CLUSTERED ([UserName] ASC)
);
</code></pre>

<p>i want to update to:</p>

<pre><code>CREATE TABLE [dbo].[User] (
    [UserName]  NVARCHAR (100) NOT NULL,
    [Pasword]   NVARCHAR (100) NOT NULL,
    [Name]      TEXT           NOT NULL,
    [LastName]  TEXT           NOT NULL,
    [Location]  TEXT           NOT NULL,
    [profesion] TEXT           NOT NULL,
    [Email]     NVARCHAR (50)  NOT NULL,
    [Gender]    TEXT           NOT NULL,
    [moneyinmillions] INT NOT NULL, 
    PRIMARY KEY CLUSTERED ([UserName] ASC)
);
</code></pre>

<p>the problem:</p>

<blockquote>
  <p>an error occurred while the batch was being executed</p>
</blockquote>

<p>thanks for the help</p>