Just adapted a function I have to strip different characters, this won't give you a small int, but do you really need this to be a small int. Where I...

Did you set the properties of SQL Server Agent Alert System to Enable the mail profile you set up?

Right click on SQL Server Agent, Select Alert System and ensure...

I think you may also need to convert the ''''00000000-0000-0000-0000-000000000000 into an uniqueidentifier as well to compare them.

DECLARE @compid UNIQUEIDENTIFIER

SET @compid = CONVERT(UNIQUEIDENTIFIER,'00000000-0000-0000-0000-000000000000')

AND ([KeyId] = '''+@KeyId+''' OR +'''CONVERT(UNIQUEIDENTIFIER,@KeyId)+''' = '''+@compid...

alter PROCEDURE AppLog_AdHoc

@Severity INT = ''

,...

I haven't worked with SQL 2000 for quite a while but I remember seeing this before. If I remember correctly I dropped the job restarted SQL Server and tried setting...

Does sending a test email work? If it does did you set the properties of SQL Server Agent Alert System to Enable the mail profile you set up?

I had a quick look around for articles on setting up log shipping, I have documentation for how I set it up but I need a warm standby server so...

Have you looked at the built in Log Shipping that comes with SQL Server as this could be used to set all the process up for you.

Try something like

=IIf (sum(Fields!Terminations.Value + Fields!TransferOut.Value + Fields!HeadcountEnd.Value) = 0, 0,sum(Fields!Terminations.Value + Fields!TransferOut.Value + Fields!HeadcountEnd.Value))

How did you do the migration? have the databases been reindexed after the migration?

See http://www.sqlservercentral.com/articles/SSIS/64028/

you've missed out the FROM

delete FROM tableName where path like '''%'+@path +'%'''

try to see if it will delete the correct record using a select statement first to test.

The fuzzy match that's in SSIS would be useful to use in some way on selecting data, Full Text just doesn't do it well enough.

Down load a trial of SQL Sentry if a deadlock fires it should give you the items that are in the chain of events. http://sqlsentry.net/sql-performance

There is a script to do just this on the microsoft site look for sp_helprevlogin in google