Add CHAR(13)

Ex:

CASE WHEN NewTitle IS NOT NULL THEN 'HR Change for: '+ CAST(FirstName + ' ' + LastName AS varchar(100))+ CHAR(13) + ', Previous Title: '+ CAST(OldTitle AS varchar(800))+', New...

If you have a database with Bulk/Full logging enabled you should schedule transaction log backups to run regularly, this will help keep them clean so-to-speak. If you haven't already...

There's really no difference in using the GUI over TSQL other than it writes the TSQL for you. For instance, with the GUI you can click a checkbox to...

I'm very familiar with Jeff, Gail, and many countless others. My comment was more of a personal joke to Sean because a few weeks back he made a comment...

Hey Sean, does Jeff send you some sort of royalty checks in the mail from time-to-time? 😉

(heh, heh)

Well Duh, Sorry Sean...I only read the first part of your post when I went off and replied. It's going to be a long week...

You could also pass in the parameter (sort column) into the actual procedure itself (similar to how the infamous sp_whom2 stired-procedure works. It uses a little dynamic SQL but...

Thanks Lowell (and everyone). I went into the msdb db and added a the development group to the mail profile and it worked!

Issue resolved.

Viiki.seth, yes the service account has the proper permissions.

Patrick, the article was good and don't know how I missed that when i searched for it on this site 🙂 ...

My destination already is OLE DB... has anyone found a solution?

I am running this under SQL 2006 Standard, SP2, on a Windows 2008 Server Enterprise - 64-bit

I've had issues before using the admin shares like that across servers. Get rid of it. Create an actual...

Actually, from one of the links on the page I offered there's a link to an example of exactly what you need to do to implement it:

https://community.altiusconsulting.com/blogs/altiustechblog/archive/2009/09/07/sql-server-2008-change-data-capture-example.aspx

It's pretty straight-forward

Without using a 3rd party tool or triggers I don't think you have much left to work with. In futhering what Sean has said: http://msdn.microsoft.com/en-us/library/bb522489.aspx

Good god yes, as SQL RNNRPointed out, keep track of any and all emails to your boss about the process! When things come up that will take you away...

Transactional Replication should run all the time...as it is by default, but if you do schedule it somehow there shouldn't be an issue with it running into one another. ...