PLease also attached the data (or a subset of it)

GilaMonster (1/3/2012)

---

Err, that (headline article today) is the updated version. Unless you're volunteering to rewrite...

LMAO - that was awesome!

And Err, no, definitely not that 😉

I liked the article (not to brown-nose) and will look forward to the updated version!

I agree with Gail that this should be posted in a new thread, but based on what you posted it soulds like your database is using the bulk_logged or full...

I've got a log reuse type of LOG_BACKUP, but there's no transaction log backup running. I've run a maintenance job to see if that would clear out my LDF...

Thanks suresh,this was indeed the issue!

Checkdb returned:

DBCC results for 'Auth_Primary'.

Msg 2511, Level 16, State 1, Line 1

Table error: Object ID 1888777836, index ID 23, partition ID

72057594511949824, alloc unit ID 72057594551074816 (type In-row data).

Keys out of...

SQLRNNR (12/30/2011)

---

Nah - you can delimit the results in the mailed file using

@query_result_separator = ','

That said, you can replace the separator value with a |, tab, or something else if...

The output in the attachment is the same as if you ran the query with "results to text" instead of to "grid" and that's why it looks the way it...

Something simple like this should work, if your file is blank there's another...

We have a lot of that same logic (using updlock/rowlock) riddled throughout our 3rd party code (coreCARD) and it's there because of the way the transactions are being processed. ...

You could create the maintenance plan to delete the files (using the Maintenance Cleanup Task) then "script" it out so you can see the TSQL that is generated by it....

Is the back Tlog SQL Agent job/script still running?

Looks like CoreCard to me...