replication and datetime columns

I have an interesting server occuring. We have transactional replication running with 1 pub and 6 subscribers. On nearly all the tables we have some sort of date column that's a smalldatetime. If I look at the pub the data will appear like:

2006-11-13 09:59:00

However, on all the subs it appears like:

2006-11-13 09:59:00.000

It's the same column and record but for some reason it's become a datetime. I checked the column types and they are both smalldatetime's.

Why is this happening? What can be done?

Thanks,

Phil

I am unable to repro this on my SQL 2000 and SQL 2005 servers. What version of SQL Server are you running and what SPs?|||

Actually I found the problem. It looks as if when you use the four part name server.db.dbo.tablename from the publisher that the column "appears" to be a datetime. When I actually go to the server and select it.. then it's the normal smalldatetime. I don't know if this has something to do w/ ODBC connection accross linked servers or what...

Thanks,

Phil