Nice article.

- I'd move the tables to msdb because they "belong" to the job system of your sqlserver.

- Since security is your main concern, I'd avoid the use of "grant...

you are usingn the @BCClist for as well the @To as the @BCC parameters !!

Only use one of both parameters to start with.

CREATE PROCEDURE dbo.proc_happyBirthday2

AS

BEGIN

...

Indeed, changes to the underlying table's column order will make a bitmapped trigger buggy, and there is no way you can avoid it becomming buggy ...

Best is to seal it...

you can provide the location at install time:

- using the install GUI (advanced button)

- or using an installation INI file.

there is a template.ini file on your...

afaik : Yes you will have problems !

They can open in tran-scope, but they can only be closed after the tran-scope has completed.

Reason: MSDTC needs open connections to perform the...

well ... the "old" way ..

in stead of sending one mail to x recepients.... send x maild to one recepient at a time.

seems like a bug in your xpsmtp ...

Is...

columns_updates just says is a column is updated, it does not contain the value.

from bol

To test for updates or inserts to specific columns, follow the syntax with a bitwise operator...

- is this step run with another user than the rest of the job?

-since you're on sql2005 (forum) did you try it with dbmail ?

(avoid the overhead of mail-client)

If you put your db-files on a remote disk, you are network dependant !!! (availability/latency).

Sans are directly connected to your server and are prefered.

Sans are used like any local drive,...

like it says User Defined Function is supposed to perform some kind of

functionality (e.g. calculation, regex, ...) for you.

Most of the time based on parameters (row-level !).

Keep it...

- 8004005 is most of the time an authority issue.

- are you sending attachements ?

- post the jobstep / full job create script, maybe we can help out.

I would suggest to use the tool it is normaly managed with.

i.e. dcomcnfg

Especialy if you are not familiar with these settings !

Keep in mind these are also security settings !!!

You...

why would you even think of using dynamic sql for this ??????? :sick:

If you know it's only the predicates that differ, why not have a bunch of if statements...

first of all you'll need sql2000 enterprise edition !

This is the ref I always use : http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

- Did you take a look at log-shipping ?

- or work with full backup once a week and the other days restore the db and apply (the smaller)...