Unfortunately you cannot do a truncate table on the data since you will get the good data too. Some things that might help is to do the deletes in pieces...

Unfortunately unless you create a mapping table to translate mistakes or consider trying partial matches you don't have too much you can do. Soundex may help some but not always....

I beleiev it has to do with the way you call xp_sendmail. Like sp's you have to have EXEC in front for it to run.

Try

EXEC master..xp_sendmail

@recipients = 'Brady, Kelly',

@subject =...

If I come across anything different I will try to pass a long.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Not sure there is any need for concern as I find no listing of an issue with this. May be waiting for the replication finished reposne from the subscriber. Have...

Not to my knowledge.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

David is right, except 1 error.

SUBSTRING ( expression , start , length )

last parameter is length not ending position so

substring(TRAILER_COUNT, 12, 5)

"Don't roll your eyes at me. I...

First what type of replication and how much data replicated at a time, and how long are we talking?

"Don't roll your eyes at me. I will tape them in place."...

3 part Answer

1) Cant figure out why I am getting an error with the following script:

See 3

2) Is there a way to Concatenate the values from two columns in...

Not yet as most of the items have counter parts in Performance monitor and Microsoft is trying to get rid of SQLPERF in favor of Performance Monitor (Even says it...

Rick is right about the server reinstall. However you can set the collation at the database level so the database should be fine with the spanish collation at the DB...

To answer your base question, yes. ADO is just building the string which your developer can do himself and I have done on serveral occasions myself. However there are some...

quote:

---

Just to make clear, the stored procedure I'm alluding to has six sections. Each uses the search criteria to add rows to...

The key to a fill factor is in the page splits, but keep in mind that the fill factor never resets itself once built in the begining. Meaning if I...

Which server is it referring to.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)