You will have to test it yourself in Query Analyzer by producing the plans and studying them.

The NOT FOR REPLICATION property also applies to Triggers!

Yes!

The ISNULL Function is simply replacing all NULL host_id with the GETDATE() Function. If you do not want to do that then just remove the ISNULL Function.

Have I understood, or...

How have you ascertained that the table is been locked up? Are you talking about Table Locks?

Try this,

DECLARE @Time NVARCHAR(20)

DECLARE @Minutes INT

DECLARE @NewTime NVARCHAR(20)

DECLARE @HoursToMinutes INT

DECLARE @Hours INT

DECLARE @Position INT

SET @Time = '211:34'

SET @Position = PATINDEX('%:%', @Time)

SET @Hours = SUBSTRING(@Time, 0, @Position)

SET @Minutes = RIGHT(@Time, 2)

SET...

Yes. I do something similar here. Give it a go, it should work.

In Transactional Replication, the Subscription Database becomes a "Logically read only" Database. Therefore, because there will be no Inserts, Updates or Deletes happenning at the Subscriber, the Unique Constraint is...

Natively(SQL Server) speaking, I don't think that is possible. The closest thing you can do is use the PWDENCRYPT() function to compare passwords against.

Try uninstalling SQL 7.0 first and then reinsatll .Net 2003.

The IsEmpty Function in SQL Server is for Analysis Server only!

Show us your code and we can go from there to assist you.

You can't directly replicate any sort of data from Exchange to SQL.

You could probably look at exporting the data from Exchange to a csv file and then create a DTS...

Do both SQL Servers have the same service pack?

Sounds like the entire replication process has got itself into a knot. You may have to drop replication and set it up again from scratch without doing the snapshot!

You need to,

(A) Use sp_repladdcolumn to add columns to a Table that is marked for replication.

(B) configure the snapshot properties to either drop the table or truncate it etc etc....