Backup...

Is there a way to find out when the data in a table was
last updated?
How does Sql Server keep track of it?
Thank you in advance,
-TinaSQL Server keeps track of updates to the data via the TRANSACTION LOG.
There are a number of third party tools available to read through the
TRANSACTION LOG. One such product is LOG EXPLORER by Lumigent
(http://www.lumigent.com/).
You might also try using the undocumented DBCC LOG command
Here is schetchy documentatrion.
The following undocumented command will do the trick.
DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.
type - is the type of output:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length)
2 - very detailed information (plus object name, index name,
page id, slot id)
3 - full information about each operation
4 - full information about each operation plus hexadecimal dump
of the current transaction log''s row.
by default type = 0
Best way to easily identify updated records is of course to design a
LAST_UPDATE_DATE column into your table design, but of course I don't see to
many folks doing this these days.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Tina" <anonymous@.discussions.microsoft.com> wrote in message
news:123cf01c44275$db2cf520$a501280a@.phx
.gbl...
> Is there a way to find out when the data in a table was
> last updated?
> How does Sql Server keep track of it?
> Thank you in advance,
> -Tina
>|||Hi Gregory,
Thanks for the reply. I tried the following commands
I get the error "[Microsoft][ODBC SQL Server Driver]
Syntax error or access violation"
DBCC log ({DB1},{3})
DBCC log ({dbname=DB1},{type=3})
DBCC log ( {DB1}, type={3)) where DB1 is the name of my
database.
What am I doing wrong?
I am running it using Query Analyzer.
Thank you,
-Tina

>--Original Message--
>SQL Server keeps track of updates to the data via the
TRANSACTION LOG.
>There are a number of third party tools available to
read through the
>TRANSACTION LOG. One such product is LOG EXPLORER by
Lumigent
>(http://www.lumigent.com/).
>You might also try using the undocumented DBCC LOG
command
>Here is schetchy documentatrion.
>The following undocumented command will do the trick.
>
>DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
>
>
>
>
>PARAMETERS:
>
> Dbid or dbname - Enter either the dbid or the name of
the database
> in question.
>
> type - is the type of output:
>
> 0 - minimum information (operation, context,
transaction id)
>
> 1 - more information (plus flags, tags, row length)
>
> 2 - very detailed information (plus object name,
index name,
> page id, slot id)
>
> 3 - full information about each operation
>
> 4 - full information about each operation plus
hexadecimal dump
> of the current transaction log''s row.
>
>by default type = 0
>
>
>Best way to easily identify updated records is of course
to design a
>LAST_UPDATE_DATE column into your table design, but of
course I don't see to
>many folks doing this these days.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Tina" <anonymous@.discussions.microsoft.com> wrote in
message
> news:123cf01c44275$db2cf520$a501280a@.phx
.gbl...
>
>.
>|||You need to remove the curly braces. Try using:
dbcc log(DB1, 3)
-Sue
On Tue, 25 May 2004 16:10:19 -0700, "Tina"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Gregory,
>Thanks for the reply. I tried the following commands
>I get the error "[Microsoft][ODBC SQL Server Driver]
>Syntax error or access violation"
>DBCC log ({DB1},{3})
>DBCC log ({dbname=DB1},{type=3})
>DBCC log ( {DB1}, type={3)) where DB1 is the name of my
>database.
>What am I doing wrong?
>I am running it using Query Analyzer.
>Thank you,
>-Tina
>
>
>TRANSACTION LOG.
>read through the
>Lumigent
>command
>the database
>transaction id)
>index name,
>hexadecimal dump
>to design a
>course I don't see to
>--
>--
>message