March 10, 2015 at 12:09 am
Comments posted to this topic are about the item Reading Logs
March 10, 2015 at 12:50 am
Excellent question and the 3 links you provided to explain the "good answer" were ( maybe ) the best ones.
It was easy for me to answer as I am studying everything coming from MSSQLTIPS and I have only to search in my own remembrances to retrieve the good solution ( not too difficult as I knew this tip was created in the last autumn ).
March 10, 2015 at 2:23 am
Nice question, thanks Steve!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 3:47 am
Thank you, good question Steve.
Thank you Tony Davis & Gail Shaw for your help in knowing this answer.
March 10, 2015 at 5:22 am
So often, I learn something from the QOTD. Thanks.
March 10, 2015 at 7:26 am
I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't determine from that. Is the something in there that can be used to tie that back to a user?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 10, 2015 at 7:44 am
when it said 'easily read the transaction log', I wasn't sure, I suppose it depends how you define easy!
thanks for the reminder though.
---------------------------------------------------------------------
March 10, 2015 at 8:35 am
Excellent question. Thanks Steve
March 10, 2015 at 9:01 am
I answered correctly but really thought a 3rd party product would have been 'easy'.
March 10, 2015 at 11:38 am
Very witty - thanks, Steve!
March 10, 2015 at 11:54 am
Thanks, Steve!
I had no idea this function existed. Much appreciated.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
March 10, 2015 at 12:07 pm
Sean Lange (3/10/2015)
I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't determine from that. Is the something in there that can be used to tie that back to a user?
Please check this out
select SUSER_SNAME([Transaction SID]), *
from fn_dblog(null,null)
March 10, 2015 at 12:30 pm
raulggonzalez (3/10/2015)
Sean Lange (3/10/2015)
I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't determine from that. Is the something in there that can be used to tie that back to a user?Please check this out
select SUSER_SNAME([Transaction SID]), *from fn_dblog(null,null)
I was in the same boat as Sean on the "who did it" part.
March 10, 2015 at 12:58 pm
raulggonzalez (3/10/2015)
Sean Lange (3/10/2015)
I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't determine from that. Is the something in there that can be used to tie that back to a user?Please check this out
select SUSER_SNAME([Transaction SID]), *from fn_dblog(null,null)
Excellent!!! Didn't know that existed. Thanks for sharing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 10, 2015 at 1:16 pm
Sean Lange (3/10/2015)
raulggonzalez (3/10/2015)
Sean Lange (3/10/2015)
I knew about fn_dblog but answered that you can't do it without third party because the question was asking for "whodunnit" which to the best of my knowledge you can't determine from that. Is the something in there that can be used to tie that back to a user?Please check this out
select SUSER_SNAME([Transaction SID]), *from fn_dblog(null,null)
Excellent!!! Didn't know that existed. Thanks for sharing.
I knew of the function to return the login for the current connection, but I thought it was like GETDATE() where you just provide the parentheses because they're required. I guess I should take a closer look at some of those functions once in a while.
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply