Here is a hint: You will need to join sysjobs and sysjobhistory to identify the job you you are looking for by name (Audit).  You want to loop as long...

If you are doing the Full Backup in place of the Transaction Log Backup, that is why your 7:00 Transaction Log is bigger.  The Full Backup does not truncate the...

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...