The only limit that I know of is the record limit for SQL 2000. That is 8060 bytes. You have three nchar(1000). That comes to only 6000 bytes and you...

That is correct.

Is it possible to test it by renaming the column to reason2 and try adding it?

Now I am beat. Sorry. Dont have any clue why it should throw that error. Maybe someone else can help you. As far as I know, REASON is not keyword.

You can alter the stored proc used for replicating the inserts to suit your needs. The SP will be in your subscriber DB (TestDb). The stored proc will have the...

Can you try running this query?

select

name

from

sys.columns

where

object_id = object_id('Tablename')

This happens only in this publication? Do you have a user defined data type in this table? I do not think it is the column name that is the problem...

Make sure that you have UDP port 1434 open for the SSMS or SQL 2000 tool to connect. Also when using SQL 2000 tool to connect to SQL 2008, it...

I did what I can. I hope it helps.

pwalter, Please keep in mind that SQL Server is too vast to have knowledge in all areas. For instance, I am not a T-SQL guru. I have more than 10...

Really good Job. You handled him quite well. And the last...

It would be a mistake from their part if they gave MVP award just to people who runs a UG. For example, I run a UG just like Gail said,...

Thx for the Update Jimmy.

Restoring mode comes up when you have log shipping. Not for transactional replication.

Yes, you are correct, the developers should not delete records on their test server (Subscriber). Also keep...

If it need to be pretty fresh, then your option is transactional replication. But there is a drawback when you want to use it.

You cannot allow your developers to...