install replication components on cluster

Hi,
At the SQL Server cluster installation time I haven't choose the replication component(wasn't required at that time). Now it is and when I run again the setup to modify the installation and to add the replication components it doesn't give me that option.
The only option that I have is to uninstall the SQL Server.
Is it what is suppose to be? If yes how can I install the replication components?
Cata,
replication isn't enabled from the setup. If you use EM, and go to tools,
replication, configure publishing... you can set it up there.
Regards,
Paul Ibison
|||Thanks for your replay.
At the setup time when you install the SQL Server one is
asked if he wants to install the Replication components -
so there are some components that have to be installed. I
haven't choose that option.
Additionally when I am choosing to configure replication
EM - Tools - Cofigure Publishing, I get the message "The
Replication components were not included when SQL Server
was installed on <server>"

>--Original Message--
>Cata,
>replication isn't enabled from the setup. If you use EM,
and go to tools,
>replication, configure publishing... you can set it up
there.
>Regards,
>Paul Ibison
>
>.
>
|||My apologies - I had selected this checkbox without thinking when I installed, which was a while ago. I'm out of the office for a while but if no-one else answers in the next few days then I'll try on a test cluster I have built back at work. I suspect yo
u'll have to break the cluster then add the components, but I'll have a look.
Regards,
Paul Ibison

Insert-Retrive-Update in Text datatype.

Can anyone guide how to retrieve, update and insert data in column having 'Text' datatype? I am a newbie and i havent' done this yet.

Thanks in advance.

If you are using SQL Server 2005 consider using a VARCHAR(MAX) or NVARCHAR(MAX) instead of a text datatype. Look up the VARCHAR(MAX) and TEXT datatypes in books online.|||

No. i am using sql 2000 and i wanted to know the method of retriving and updating data usign text datatypes.

thanksk,

|||Use it in the same manner that you would use a normal varchar column. The only difference is that when using it in a where condition you can't use the '=' operator. You have to use 'like'. Other than that inserting, updating and retrieving is exactly the same.

Best regards,
Sami Samir|||

Please see the links below for some samples. For text/ntext/image value manipulation, you can use UPDATETEXT/WRITETEXT/READTEXT or SELECT/INSERT/UPDATE statements depending on your needs. There are functions like DATALENGTH and PATINDEX that will work with these data types too.

http://www.umachandar.com/technical/SQL6x70Scripts/Main53.htm

http://www.umachandar.com/technical/SQL6x70Scripts/Main63.htm

http://www.umachandar.com/technical/SQL6x70Scripts/Main12.htm