1

Topic: How to learn who deleted a line in the table?

How from a broad gull of transactions this  to get?
Type  that-thread is available for a msec ?

2

Re: How to learn who deleted a line in the table?

https://habrahabr.ru/post/111207/
The old article, but for to esteem and understand that to what goes

3

Re: How to learn who deleted a line in the table?

Konst_One wrote:

https://habrahabr.ru/post/111207/
The old article, but for to esteem and understand that to what goes

It for those who read it before it was required to learn smile

4

Re: How to learn who deleted a line in the table?

+1

5

Re: How to learn who deleted a line in the table?

TaPaK wrote:

it is passed...
It for those who read it before it was required to learn smile

It is exact.
Interests  dml from a broad gull of transactions.
What, not  so  the server?

6

Re: How to learn who deleted a line in the table?

Goats wrote:

As from a broad gull of transactions this  to get?

In results fn_dblog to find operation of removal of this line.
Further in the same place to find the beginning of appropriate transaction - in column Transaction SID will be required.

7

Re: How to learn who deleted a line in the table?

invm wrote:

it is passed...
In results fn_dblog to find operation of removal of this line.
Further in the same place to find the beginning of appropriate transaction - in column Transaction SID will be required.

I look that about fn_dblog write - any .
Can result a specific example?

8

Re: How to learn who deleted a line in the table?

From a sectional broad gull to get the information it is possible only black magic.

9

Re: How to learn who deleted a line in the table?

Sergey Alekseevich wrote:

From a sectional broad gull to get the information it is possible only black magic.

Well  for example can view broad gulls, archive.
I understand that  the server is not professional , but it can too so can?

10

Re: How to learn who deleted a line in the table?

Goats wrote:

it is passed...
Well  for example can view broad gulls, archive.
I understand that  the server is not professional , but it can too so can?

Eee, in  is not present possibility to delete the information from a broad gull? However. So there will be heavy expenses on storage systems.

11

Re: How to learn who deleted a line in the table?

Goats wrote:

I understand that  the server is not professional , but it can too so can?

Well, companions, will be still conducted on such divorce and to it seriously to answer? 8-o

12

Re: How to learn who deleted a line in the table?

o-o wrote:

it is passed...
Well, companions, will be still conducted on such divorce and to it seriously to answer? 8-o

But it it is unreal it is abrupt!

13

Re: How to learn who deleted a line in the table?

o-o wrote:

it is passed...
Well, companions, will be still conducted on such divorce and to it seriously to answer? 8-o

It  smile

14

Re: How to learn who deleted a line in the table?

Goats wrote:

but it can too so can?

Can.
Show professionalism and find this information independently.

15

Re: How to learn who deleted a line in the table?

Goats wrote:

it is passed...
Well  for example can view broad gulls, archive.
I understand that  the server is not professional , but it can too so can?

[spoiler]
Here it. For a long time it was necessary to tell sql server - nonprofessional , and a shit piece. Conduct bases by means of a leaf of parchment, a goose pen and a can of ink.
[/spoiler]

16

Re: How to learn who deleted a line in the table?

The moderator: 2 Goats: will be all  -  in  time.
While it is opened.