CHAR(10) + CHAR(13)

just search for "parameter sniffing" on these forums

Unfortunately isnumeric is NOT reliable for your case

You may want to use LIKE or patindex instead

you are not leaving an space after the -S, are you? try: -SmyServer

Not sure exactly what you are after but Profiler may be the tool you are looking for

The deleted table can get more that one record!

 it happens every time a batch ( with updates or deletes)that affects more than one record is executed.

Triggers should ALWAYS be coded...

Sorry for not comming back earlier. Let's try this again, shall we ?

is the DISTRIBUTOR running under the SQL Server Agent account?

Like I said check :

Go to 'Configure Publishers,...

database in simple !?! ...  I hope your DR requirements are very relaxed

Select upper(Left(@str,1)) + substring(str,2,Len(@str)-1)

did you check it ?

did you run :

exec sp_dropalias @loginame = 'THE-SQL-LOGIN' on that database ?

 Under 'Configure Publishers, Subscribing, Distribution' then the Publishers Tab, hit the ellipsis button for 'distribution' and find what account is being used.

Make sure that if it is 'sa' you entered...

>>Just curious to know the reason<<

The reason: <sarcasm>

I bet your user is aliased!!!

run sp_dropalias on the login

and your queries should perform as you expect

the error that you are getting has nothing to do with constraints!!

You are simply importing the wrong value in the wrong column!!