find action on log file

Hello there

I want to use outside tool to find who made some update on table in my 
server

I know that there are many tools for this. But can they do it on simple 
recovery model? 


0
Roy
8/3/2010 12:07:25 PM
sqlserver.programming 1873 articles. 0 followers. Follow

1 Replies
734 Views

Similar Articles

[PageSpeed] 4

Roy Goldhammer (royg@yahoo.com) writes:
> I want to use outside tool to find who made some update on table in my 
> server
> 
> I know that there are many tools for this. But can they do it on simple 
> recovery model? 
 
No. If you are using the simple recovery model, the contents of the 
log is wasted away everyonce in a while.

Well, if the disk area has not been overwritten, you may be able to disk 
forensics on it, but that will cost you an arm and a leg.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0
Erland
8/3/2010 6:54:26 PM
Reply:

Similar Artilces:

Help needed with Money 2003 files
Hi there, I've been using money 2003 for years even when upgrading to new PC's as I had the original disk. I've just had to rebuild my hard drive and now cannot find the disk anywhere so cannot install Money. As you cannot now buy Money, I've tried downloading the trial version of Money so that I can access all the account details/balances but it says that they're not compatible with earlier versions of money. Is there anything that I can do to get these files open or have I lost all my records for the last 6 years? I'd really appreciate your assistance. Jayne EggHead...

Finding merged cells #2
Sorry for posting 2 messages with ref to the same problem but I am in dire need of a solution... I seem to have a problem due to cells in a worksheet being merged, how can i identify these cells? Many thanks, Rick Excel version? If you have 2002 or 2003 you can use Edit, Find, Format (and specify merged cells), Find All. -- Jim Rech Excel MVP "R D S" <ricknewsgroup@members.v21.co.uk> wrote in message news:385u2aF5kslgkU1@individual.net... | Sorry for posting 2 messages with ref to the same problem but I am in dire | need of a solution... | | I seem to have a problem d...

Archive Money File
Need a little help. I've been using Money since it first came out many years ago. My .mny file is now 35,444KB after I archive all the transactions prior to 1/1/2004. I have bought and sold a lot of stocks, bonds, cars, etc. over the last 10 years or so. Is there any way to clear out the old "investment" transactions without affecting the networth history? Nope. For many reasons, archiving is lame and destructive and many of us recommend against it and do not do it ourselves. My file is well over 50 MB. I live with it and rather prefer that all of this historical ...

hosts file
Hi all, After I modified HOSTS file in another directory I can not replace the one on windows/system32/drivers/etc. He account I use is administrator. I have windows vista home premiun SP1. By the way a virus altered HOSTS file and can not connect to internet with firefox, I added 127.0.0.1 to the file in order to make it work. Thanks a lot for any help. perhaps a freeware called spybot can help. first immunize then go to the tools section and see if the hosts file is visiable. in any case here is some more info: http://tinyurl.com/yafnssc -- db���...

Incorrect formatting opening .csv file in Excel
When opening a database generated .csv file with the following data: "1","10E-024","1" Excel opens it incorrectly formatting the text as a scientific number: 1 1.0E-24 1 If I save the file as .txt, and open in excel using the import wizard, I can specify that the column should be text, and the item code 10E-024 appears correctly. However this is far from ideal, as it relies on a manual step and the file cannot be saved as .csv again - otherwise the same fault happens next time the file it opened. Is there a way of forcing Excel to open .csv files in raw da...

get the username of the logged on user
I am creating a windows service which is running under Localsystem account. How can i find out the username of the currently logged in user. GetUserName() function returns "SYSTEM". Even the GetTempPath() function returns the path of systems temp directory. And every access to HKEY_CURRENT_USER registry key gives me wrong information as the current user in such case is .Default Can anyone please tell me a way to find out the name of the logged in windows user??? The service has to run in system context so i cant change it. Thanks in Advance... "Rohit Kumar" <Roh...

how to change default delivery location to my new pst file
dear all. my user has outlook 2000 sp3 running on windows 2000. i have change the default delivery location to my new pst file in account manager, but it did not work, new email is delivered to old pst file. do you have any idea on resolving this issue?? Try renaming the old .pst to .old and then retry it when Outlook is opened - point it to the new .pst file. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, sf= asked: | dear al...

Is there a way to change the effective date on EFT transmit files?
I'm trying to determine if there is a way to adjust the effective date that is located on the transmit file for EFT file transmissions. Our transmit files show the current date as the effective date for our batches. We'd like to see a day or 2 later. I believe the location of this "effective date" is between characters 70 and 75 on the 5 record (company/batch header for all entries). ...

Outlook 2002 Vcard attachment shows as a .msg file-opens but no information
I am receiving forwarded attachments as a Vcard file from a contact list. It shows up as an envelope on the attachment and as a .msg file. It opens but there is no information there other than a name. Is there a setting in Outlook that is incorrect or is this something to do with a setting in the Microsoft Exchange Server Administrative Rules. I have searched the knowledge base and cannot find any specific answers yet. Anyone have any feedback on this or the same problem? Help! Thanks. Carl ...

How to find all the properties associated with an object
In VBA when you type something like Sheets and then a period you are given a dropdown list of what can be associated with Sheets. I have on many occassions had great help from many in this group that give instances such as "ActiveSheet.ShowAllData" where typing in ActiveSheet and the period reveals no such list. Is there somewhere or somehow a method that I can get the full (or fullish) list where the objects' properties are not given? Rob "rob nobel" <robnobel@nospamdodo.nospamcom.nospamau> wrote... .... >where typing in ActiveSheet and the period reveals n...

Filing away posting Journals
I am wondering according to which number i should file away my posting journals in GL,PM,RM,BM I need a consistent filing system for my client,since he doesn't like the fact that GP has no auto batch number. another question: how can i trace a paybles transaction from payables to GL in Payables Management (in other words i want to see the gl transaction from payables) Thanks ...

how to find used region with macro
Hi, sorry if this obvious or has been asked recently. I have a macro that goes through all rows and all columns in a selection. If a row or a column is hidden, the font of that row or column is changed. A friend wants to use the macro in a Workbook with many sheets. He asked if I could change it so that he does not need to do a selection on every sheet before he runs it. I imagine that a nested loop through all rows and all columns will take a long time? I�ve tried to figure out how to get the range defined by the last row and the last column filled with data. First I tried with Current...

Unable to open MDE file
Hi, I am using office 2000 and I am unable to open an Access file. I receive the following error message "You cannot convert or enable an MDE file". I was able to open this file till yesterday. I haven't installed any software since yesterday which safely rules out any problems due to a third party software etc. Hoping for a quick resolution to my problem. Thanks , Nik Hopefully you still have access to the .mdb file from which the .mde was created. You don't state which version the .mde was created in. In any case, there's precious little you can do with one...

XmlDocument does not release the Xml file
Hello, I am finding trouble while using XmlDocument class to parse my xml documents reside in file system. The problem is, I have a function that loads the XmlDocument and the function is called many times during the execution context; the first call goes ok but the second call throws the exception that 'File is being used by another process'. I am writing the function this way. public void ReadXml(string path) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(path); XmlNode node = xmlDocument.SelectSingleNode("/Employee[sal > 30]"); blah blah blah } an...

Finding Memory Leaks
Hi all, I have a MFC/C++ Application developed. I see a lot of Memory Leaks Dump in the Visual Studio output window when run the app via the debugger. My application consists of an exe, and a few DLLs. The DLLs are loaded by the exe using LoadLibrary. And any memory leaks are in any of the DLLs, there is no info like where in the sourcecode (file name and line number) where the leak was caused. All that I see is the number of bytes of leaked. Whereas, any leak in the EXE shows exact info about file name and line number. Any help/tips/suggestions to help me solve the memo...

ie8 log on to this board is weird
Running XP, SP3 - Whenever I try to get on this board, I go to the log on screen and put in my log in info and then I get the ie window that says it cannot open this web site and it lists a couple of options to check for connection etc. However, if I immediately click on the link to this website in "Favorites" again, it opens up the site and shows me logged in. I have to go through this every time I try to get on the site. Is is something in my INternet Options settings?? Also, is there a setting that makes the browser open up maximized, instead of small screen by...

[Excel 2003] problem in files with pivottables after install Office Service Pack 3
Hi all. System: Windows XP Pro SP2, Office 2003 Professional + Service Pack 3 I have a problem with some xls files after install office service pack 3. With service pack 2 this files normal open. With service pack 3 after open file displays dialog (my translate from russian) "In workbook ... have contents which can not be read. Try restore contents of workbook ? If you trust source of this workbook, press button YES". If I press "No" - file not opens. If I press "Yes", displays next dialog. This dialog form content a list of corrections in file. Biggest pa...

IE8 , Network Share / Drive Map
A client system (XP SP3, Novell Network ZENworks/Groupwise, Non-Admin account) here is having issues saving documents from within IE8 to her assigned Network drive. (I know more technical details for the network/setup may be warranted but for now I'm hoping someone has seen this or knows a fix based on this basic info) None of her mapped network drives show up as possible save locations from within the IE8 "save as" dialogue. Her drives are working fine otherwise; she can read, write, delete, etc. to them from Windows Explorer and other programs. There doesn't seem to be a...

Listing files with full path
Is there any function which acts like Dir but returns the full path of the file and not just its filename? I want to find files of a type in several directories, load the names in an array then go through them all and process them. It would help if the file names in the array contained the path information so that the part of the macro which does the processing can go straight to the file without having to worry about which folder it's in. Grateful for advice. Don't you already know the directory/folder at the time you call Dir? So just concatenate this with the file n...

.msg file access violation in Outlook
Hi, I have a .msg file that was created using Outlook 2000 SP-3. I am able to open the file only once in every boot cycle. The rest of the time I get a shariung violation (when moving/deleting) or an access violation message when re-opening in Outlook. How do I solve this? Thanks. -- AKS "dee" wrote: > Hi, > > I have a .msg file that was created using Outlook 2000 SP-3. > > I am able to open the file only once in every boot cycle. The rest of > the time I get a shariung violation (when moving/deleting) or an access > violation message when re-op...

Combining Excel files
This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C39406.568A3A80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have all my timesheets in separate files and I would like to extract = values from each file to use in analyzing my time spent on projects and = time spend doing administrative tasks, etc. Can someone give me some tips on how to get started (e.g.. how to = extract valves from one file to another) Thanks Cory ------=_NextPart_000_0012_01C39406.568A3A80 Content-Type: text/html; charset="iso-8859...

Automatically pull data from one file to populate a template
Hi Everyone... Just beginning to get the hang of vba coding in excel. I would like to implement a new feature in a spreadsheet here at the office. We currently have a master records sheet containing vital information on unit processing. Each unit then has a sub file containing additional information. Currently one must populate the master record file. Then open a template and populate another file with the same information. I would like to streamline this process and have the data in the master record file automatically inserted into the template, allowing the user to only have to ...

Logging CC transactions
When I pay a credit card from my checking I select the catorgy Credit Card Payment: MasterCard. When I look at the MasterCard account and look at the payment the catagory is empty. What should i put in that catagory. I have tried to put transfer from Checking but that seems to cause double entries in my checking account. In microsoft.public.money, Steven C. wrote: >When I pay a credit card from my checking I select the catorgy Credit Card >Payment: MasterCard. > >When I look at the MasterCard account and look at the payment the catagory >is empty. What should i put in t...

Can't Import old files
I have a system crash and had to re-install XP. My Outlook express files are on a other drive. I had that because of other experience. That worked verry good. But now i want to import my old emails and i can't get them!! I can't acces the files. I have already looked into the help in different sites but no sollution yet. I cant copy,rename, the files. I tried to get them back with DBxpress (recover program) but also that program can't open the files. It look like that the files are protected with a NO write/read function. I can deleted the files but thats not a option till i ha...

Shared Excel file
Hi, I Want to know, how fourth or more persons could have a permission t read write and modified excel file together. The excel file found on the server Thanks, Michae -- Michael ----------------------------------------------------------------------- Michaelt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1555 View this thread: http://www.excelforum.com/showthread.php?threadid=27122 tools>share workbook>editing>allow changes "Michaelt" <Michaelt.1ehhi0@excelforum-nospam.com> wrote in message news:Michaelt.1ehhi0@excelforum-nospam....