Have a look inn BOL at the definition for the LEN function... it states that it:-

Returns the number of characters of the specified string expression, excluding trailing blanks.

The trailing blank...

You don't put a WHERE clause on an INSERT statement.

I'm guessing from the name of the table that this is a link table between an Employee and a Course, so...

I've seen this issue quite a few times before... unless you specify the nullability of a column during your table creation script, you are at the mercy of the software...

The foreign...

My initial guess would be that you have a Trigger on the table.

Have a look at this, it may be what you are looking for:-

http://www.databaseanswers.org/data_models/vets_practice/index.htm

Found the article:-

http://support.microsoft.com/kb/238254

One reason to use COALESCE rather than IsNull... COALESCE is in the ANSI standards, IsNull is a Microsoft extension to the standard.

I'm sure I remember reading somewhere that any change to the Primary Key or a Unique Constraint causes the...

Are there any triggers on the table?

If so, could be one of them that is causing the issue. Recreating the table makes the problem go away because the new table...

I know this doesn't answer your original question, but why don't you change the procedure to something like this?

if @Outcome = 0

update hub_user_auth SET attempts =...

The way I've always done this is to make the last step of the script that stops the trace, load the trace file into a table using fn_trace_gettable, e.g.:-

SELECT *...

If you read the article carefully, you'll see that this column is only added if you set your transactional replication up so that it supports queued updating subscriptions (poor person's...

Yup, same goes for 2005.

I didn't think Merge replication was possible in realtime... is it?

If you have your SQL...