Any increase in replication performance upgrading to server2003?

Are there any issues with sql2000 replication on
server 2003? We are adding a new distributor and
it's OS is server2003ent. Thanks,
The only thing I've come across is that DTC is disabled by default which
affects immediate updating subscribers - see this article for more info:
http://support.microsoft.com/default.aspx?kbid=817064
HTH,
Paul

Any easy way to change column length like varchar 30 to varchar 100?

I would like to increase the length of the column from
LOCNumber VARCHAR(30) DEFAULT ''

to
LOCNumber VARCHAR(100) DEFAULT ''

without losing any data currently stored in the field.

And it has an index on it defined as
CREATE INDEX LOCIndex ON BookData(LOCNumber)

Thanks for any help.On 31 Jan 2005 07:05:21 -0800, sdowney717@.msn.com wrote:

>I would like to increase the length of the column from
>LOCNumber VARCHAR(30) DEFAULT ''
>to
>LOCNumber VARCHAR(100) DEFAULT ''
>without losing any data currently stored in the field.

Hi sdowney,

Just use ALTER TABLE:

ALTER TABLE BookData
ALTER COLUMN LOCIndex varchar(100)

No need to re-specify the default - it won't be changed.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||That works well, thanks very much
Do you know how to do this with MySQL as well?|||Found it, you use this
ALTER TABLE BookData MODIFY COLUMN LOCNumber varchar(100)