Check if you have the "NOT FOR REPLICATION" option set for the trigger. If this is set, then the trigger will not fire when the replication agent inserts/updates/deletes rows.

...

You need to be connected to the server you wish to enable replication on, and have selected that server (or a sub-component of it) in the tree.

All you need is Convert(varchar(10),PartsDueBy,101)

Jay

Use the virtual tables named "inserted" and "deleted" to examine the before and after values of columns within a trigger. See "inserted tables" or "deleted tables" in BOL for...

There's two reasons why line numbers won't do you any good. One is as Greg stated: if you have batches (GO) in your code, the line number given in...

The "AFTER" and "INSTEAD OF" syntax is new in SQL2000, they won't work on SQL7.

Jay

You can return any column value as a result from the case statement, just like you're doing constants now. For example,

Select col1, case when <some boolean condition>

then

...

You can nest case structures. Here's my previous example ammended to handle the 00 day:

create table test (

textdate char(6) NULL,

realdate smalldatetime NULL

)

insert test (textdate) values ('10898') -- Jan 8,...

You don't need to use convert if you create a string correctly formatted to your default date format setting, and then assign it directly to the datetime column.

Here's an example,...

I'll bet your table consists of more than 8 columns, doesn't it? I first reported this as a bug back with MSSQL7, but when MSSQL2000 came out, it turned...

Actually, IIf is an "Inline If", which is used within a Select statement, not a standalone "If". The T-SQL equivalent of IIf is the Case statement - the Searched...

It means that a clustered index is not a good idea on columns that change value frequently. Other columns not in the clustered index can change values as often...

Sorry about the duplicate posts. My mouse finger got a little trigger happy. (-;

I have merge replication running on 25 MSDE systems (2.0 or 2000 version), synchronizing with one central publisher. It works great. Performance is fine, but these are all...

I'm doing what you're describing, but with merge replication. But I think it would work the same. I use sp_addpublication_snapshot to create the snapshot agent for my merge...