Hi there!
Is there any way to find the user who did some transaction of update
in query analyser in certain time ?
The update was done manually in query analyser and is not through
system.
Is there any way to check it?
Any command or software to check this data as when certain table was
updated?
Thanks for the help!
7  1732 
LaMoRt (cw****@gmail.com) writes:
Is there any way to find the user who did some transaction of update
in query analyser in certain time ?
The update was done manually in query analyser and is not through
system.
Is there any way to check it?
Any command or software to check this data as when certain table was
updated?
A log reader tool might help you, although I would not really expect
the application name to be in the log. There are several vendors that
market log readers: Lumigent, Log PI, Red Gate to name a few.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
How about DDL triggers in SQL 2005
"Erland Sommarskog" <es****@sommarskog.seschrieb im Newsbeitrag
news:Xn**********************@127.0.0.1...
LaMoRt (cw****@gmail.com) writes:
>Is there any way to find the user who did some transaction of update
in query analyser in certain time ?
The update was done manually in query analyser and is not through
system.
Is there any way to check it?
Any command or software to check this data as when certain table was
updated?
A log reader tool might help you, although I would not really expect
the application name to be in the log. There are several vendors that
market log readers: Lumigent, Log PI, Red Gate to name a few.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
"BerndB" <be***@fernuni-hagen.dewrote in message
news:fi**********@tamarack.fernuni-hagen.de...
How about DDL triggers in SQL 2005
Wouldn't really help here. (Technically you want DML triggers, which were
available in SQL 2000 also).
"Erland Sommarskog" <es****@sommarskog.seschrieb im Newsbeitrag
news:Xn**********************@127.0.0.1...
>LaMoRt (cw****@gmail.com) writes:
>>Is there any way to find the user who did some transaction of update
in query analyser in certain time ?
The update was done manually in query analyser and is not through
system.
Is there any way to check it?
Any command or software to check this data as when certain table was
updated?
A log reader tool might help you, although I would not really expect
the application name to be in the log. There are several vendors that
market log readers: Lumigent, Log PI, Red Gate to name a few.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
On Nov 22, 6:13 am, Erland Sommarskog <esq...@sommarskog.sewrote:
BerndB (be...@fernuni-hagen.de) writes:
How about DDL triggers in SQL 2005
With all sorts of triggers you can capture a lot - but only if you plan
ahead. I understoof the original question as that what shouldn't happen
had already happened.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Yes, it is a data that has been updated and i want to track back the
person
who did the transaction. Any way to find it in this kind of situation.
I'm using SQL2000 actually. So anything that can help me for this?
Thanks.
LaMoRt (cw****@gmail.com) writes:
Yes, it is a data that has been updated and i want to track back the
person
who did the transaction. Any way to find it in this kind of situation.
I'm using SQL2000 actually. So anything that can help me for this?
If the database is in full recovery, you could use a log reader. There
are a couple on the market, and I've lost track of them all. Lumigent
was the first in this field, and for a long time the only player on
the market. Log PI has also been around for a while now. I see that
Red Gate has SQL Log Rescue which currently is free.
If the database is in simple recovery, or you have truncated the log
without backing it up since this update appeared, you can forget about it.
And I should add that even with a log reader, it can be quite a tedious
task to find the culprit.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
On Nov 23, 6:32 am, Erland Sommarskog <esq...@sommarskog.sewrote:
LaMoRt (cwe...@gmail.com) writes:
Yes, it is a data that has been updated and i want to track back the
person
who did the transaction. Any way to find it in this kind of situation.
I'm using SQL2000 actually. So anything that can help me for this?
If the database is in full recovery, you could use a log reader. There
are a couple on the market, and I've lost track of them all. Lumigent
was the first in this field, and for a long time the only player on
the market. Log PI has also been around for a while now. I see that
Red Gate has SQL Log Rescue which currently is free.
If the database is in simple recovery, or you have truncated the log
without backing it up since this update appeared, you can forget about it.
And I should add that even with a log reader, it can be quite a tedious
task to find the culprit.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Thanks will try it out.. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dominic |
last post by:
In our SQL database server, I set up a linked server
. In this example, the linked server simply points
back to the server.
I did the following query at the SQL query analyser, and it worked...
|
by: wiredog |
last post by:
I am struggling rewriting my query from MS Access' IIF, Then to SQL
Servers TSQL language. I am hoping some one can give me some
guidance. I believe I have the first portion of the query correct...
|
by: meyvn77 |
last post by:
I'm new to adp w/ sql server but I have to use it on a project i'm
doing...
One of the MUSTS for this project is the ability to update a 00 - 09
text value with the appropriate text description...
|
by: foldface |
last post by:
Hi
I'm expecting the answer no here but its worth asking.
If I wanted to test an arbitary program could I somehow
say in query analyser, start a global transaction on this
database, run my tests,...
|
by: Gary Besta |
last post by:
I am trying to add a simple case statement to a stored procedure or
user defined function. However when I try and save the
function/procedure I get 2 syntax errors. Running the query in query...
|
by: ElkGroveR |
last post by:
Hi there!
I'm using PHP to create a simple, dynamic MySQL SELECT query.
The user chooses a selection from a HTML Form SELECT element's many options
and submits the form via a POST action.
...
|
by: johan degraeve |
last post by:
Hello,
Put sqlsvr 2000 into single user mode (startup parameter -m added, server restarted, says it's in single mode)
used query analyser to run the following:
dbcc checkdb...
|
by: LaMoRt |
last post by:
Hi there,
Is there any way to find the person or user who did update transaction
manually
in query analyser and not through application in certain time?
As i have check thru log file but cannot...
|
by: itisjitin |
last post by:
Hi All,
1. Created table in SQL Server 2K with Primary key as int Identity
2. Link to table in MS Access 2K with child table
3. Using form in MSAccess to update the both master and child linked...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
