Obviously, you did not use UDL files for your connections.  Unfortunately, the only way to do this globally is a VB app like you have created and you cannot get...

I usually use a toothbrush and shoe polish.  If you work your way from heavy polish to the finer grades, you will have very shiny data when you are done.

If you plan to be a DBA for a significant portion of time, invest the time in learning about query tuning.  I would recommend you spare the week to take...

Take the developer that does not want to comment his code and beat him with any programming best-practices book.  I'll lay down $20 that says he will end up producing...

Just watch out for performance on this one.

To process the join to itself by date, SQL is going to probably use a cursor internally and this may cause you some...

Make sure the "On Success" of the step in the job is report success (not report failure) - sounds dumb, but I have seen this happen by accident before.

Script the...

There are arguments on both sides of this that are good.  If you do some research on the web, you can find convincing arguments for either side, so this will...

The Inserted table will have one row per updated record (or one per inserted record if doing an insert).  If you only insert or update a single row, your Inserted...

I would love to spend the time to re-write this for you, but I am afraid without your database, testing it would be pretty tricky.  I will say that this...

It's less than perfect, but you could use the host_name() to get the accessing computer name rather than the user name.  If you have regular desktop users, you can usually...

Ken is probably correct.  This happens a lot.  Try just adding a recompile to the stored procedure and see if it "solves" the problem.  If it does, take the time...

The BEGIN TRAN / COMMIT TRAN is not much overhead, but the triggers you have are inside the transaction so it may be more than you think.  Since you are...

I don't think there is a way to verify checkpoints are happening, but you can do them manually just by running CHECKPOINT in query analyzer.  I doubt they would not...

What is the recovery model set to on your TempDB?

It should be Simple so the transaction log is truncated on each checkpoint.

You can find user defined temp tables in TempDB pretty easily: select * from tempdb.dbo.sysobjects where type = 'u'

If it has a name starting with a # a bunch of...