Try this and see if you can use it.  It should take care of when the procedure is used heavily, but I'll leave that to someone else to prove or...

If it is grow so fast, it must mean there is a significant amount of transaction processing (inserts/updates/deletes).  How often to you run transaction log backups during the day?  If...

Curious, why are you storing dates as strings instead of as dates?

The field you are going to that you want formatted mmddyyyy, is this a date field or a character field?

SELECT

@sql1 = ' UPDATE CASE_NUM_SEQ' +

' SET CURRVALUE = CURRVALUE+INCR WHERE SEQ_CD = '

Instead of Database_Date or DT_DATE try using DT_DBTIMESTAMP.

Build a view over the table and access the table from your program through the view.

Peter, That is why I told him to convert the values passed to float in my second post on the subject.  However, the values he would get would not match...

I have seen this on tables with small row counts.  What you don't tell us is how many records in the table, how big is each record, and what is...

Check the Microsoft site for SQLH2, it's free.

As has been explained in the several other threads you have posted, all that msdb.dbo.sp_start_job does is start a job.  It returns...

I would use dynamic sql.  Build the approriate sql statement(s) as need based on the version of SQL Server that is being used, then execute that script using exec or...

Not enough information to diagnos the error message on the failed transaction log backup.  How is the backup device setup?  Is it on a network share?  If so, it is...

Are you missing a transactioon log backup.  The original error message you received indicated that there was an earlier transaction log backup than the one you tried to restore.

That, of course, requires that you Office (Excel) installed on your server.  I personally try to keep office of my SQL server systems as much as possible.  Using CLR, there...