Viewing 15 posts - 1,246 through 1,260 (of 1,583 total)
GilaMonster (1/3/2012)
MyDoggieJessie (1/3/2012)
I liked the article (not to brown-nose) and will look forward to the updated version!
Err, that (headline article today) is the updated version. Unless you're volunteering to rewrite...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 3, 2012 at 12:50 pm
LMAO - that was awesome!
And Err, no, definitely not that 😉
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 3, 2012 at 10:38 am
I liked the article (not to brown-nose) and will look forward to the updated version!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 3, 2012 at 10:29 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 3, 2012 at 8:55 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 2, 2012 at 8:10 am
Thanks suresh,this was indeed the issue!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 2, 2012 at 6:58 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 31, 2011 at 8:22 pm
SQLRNNR (12/30/2011)
@query_result_separator = ','
That said, you can replace the separator value with a |, tab, or something else if...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 30, 2011 at 11:42 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 30, 2011 at 11:02 am
LutzM (12/29/2011)
Wouldn't it be a lot easier to use sp_send_dbmail?For the @query_attachment_filename parameter, use a xls file extension.
Something simple like this should work, if your file is blank there's another...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 29, 2011 at 3:38 pm
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. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 28, 2011 at 9:32 am
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....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 28, 2011 at 9:21 am
Is the back Tlog SQL Agent job/script still running?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 27, 2011 at 12:59 pm
Looks like CoreCard to me...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 27, 2011 at 12:46 pm
Oh well. Consider this forum post...resolved.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2011 at 11:45 am
Viewing 15 posts - 1,246 through 1,260 (of 1,583 total)