The real question is, do you want to be a Project Manager or do you want to be a DBA\Developer? If you think you want to be a Project...

In SSIS you can use the flat file source specifying semi-colon as the delimiter and should be able to directly connect that to an OLE DB Destination.

I think you need all 3 triggers because I would assume it is possible to update just 1 of the tables. You could put a check in your triggers...

Here's one way to do this:

In the source database or on the source server create a transfer/queue table or tables with the employee primary key, action(insert/update/delete) and a...

You definitely want to get rid of the scalar valued functions in the select list. Those will be performance killers almost every time. If you can do it...

Lookup xp_sendmail in BOL. Set @query, @attach_results, and @separator parameters.

OR

If you are using 2000 and have Reporting Services you could setup a subscription in RS.

Are there any other processes running over the weekend on either the SQL Server or Oracle DB that could be causing blocking\deadlocking? Could there be connectivity issues?

Looks good to me. The only question I have is do you have the Wednesday 1 pm log backup? If you do you could potentially do a point...

I still think the right thing to do is to find the nulls, fix them, and then do not allow nulls in any of the columns you are checking.

How are...

Okay Stephanie, I'll be the first to bite. And just to be clear, I can only speak for the US.

Governmentally:

A simplified tax code, I prefer a flat income tax...

According to http://ascii-table.com/ascii-extended-pc-list.php 160 is "á - latin small letter a with acute"

If you are really using SQL Server 2005 you non longer need Outlook to send mail. You use Database Mail and the procedure sp_send_dbmail. Database Mail uses SMTP....

AS far as ANSI_PADDING goes it isn't only the setting at table creation that matters it also matters what your setting is for

insertion as well. BY default all...

Where do "test", "Tech" and "File" come into play and how do I know which one the new form_items row is going to fit into?

Why do you need the sequence...

No, it actually is not obvious. If the non-visible characters in your string are TABS then the TRIM functions WILL NOT trim them so the length will remain the...