Jeff,.

I will have to go with the later statement regarding the co-worker.  The application for which the SQL Server is dedicated to is a 3rd party app.  Yes, at times...

A little honesty, I'm not the one the one at our shop doing this.  One of my coworkers claims that it takes 4 to 6 hours daily to monitor one...

SQL only ignores the ORDER BY if you specify TOP 100 PERCENT.  If your query specified TOP 10 PERCENT (or any value less the 100), the ORDER BY is honored.

But would you watch it for hours every day?

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