how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>
|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>

how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>

how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>sql

How can I read the content of transaction log

How can I read the content of transaction log?How can I read the content of transaction log?
Use DBCC LOG to view Transaction log...

DBCC LOG

This command is used to view the transaction log for the specified database.

Syntax:

DBCC log ({dbid|dbname}, [, type={-1|0|1|2|3|4}])

where:

dbid or dbname - Enter either the dbid or the name of the database
type - is the type of output, and includes these options:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length, description)

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.

-1 - full information about each operation plus hexadecimal dump of the current transaction log's row, plus Checkpoint Begin, DB Version, Max XDESID

by default, type = 0

To view the transaction log for the master database, run the following command:
DBCC log (master)

to understand transaction log see this ...Link (http://www.windowsitlibrary.com/Content/77/21/1.html)|||Thanks :-)

How can I generate an SQL Script with the INSERT INTO instruction?

Hi,
I'd like to know if there is a way that I can generate a script with the
INSERT INTO instruction of the content of the table. I know how to generate
a script for the create table, drop the constraint, index, recreate the
table, constraint... but I need to have the content of the table into that
script. How can I do this? For the moment I do this by using a DTS that
generate a .txt file with the content of the table, and I add manualy the
INSERT INTO... instruction at the beginning of each row. A lost of time!
Thank you for your help.> I'd like to know if there is a way that I can generate a script with the
> INSERT INTO instruction of the content of the table.
http://www.aspfaq.com/5006 has a link to one such script.|||"Jacques Rhaume" <Jacques Rhaume@.discussions.microsoft.com> wrote in
message news:190EBD0A-275E-454A-851D-BF5083AD8D53@.microsoft.com...
> Hi,
> I'd like to know if there is a way that I can generate a script with the
> INSERT INTO instruction of the content of the table. I know how to
> generate
> a script for the create table, drop the constraint, index, recreate the
> table, constraint... but I need to have the content of the table into that
> script. How can I do this? For the moment I do this by using a DTS that
> generate a .txt file with the content of the table, and I add manualy the
> INSERT INTO... instruction at the beginning of each row. A lost of time!
> Thank you for your help.
http://vyaskn.tripod.com/code.htm#inserts
Try here.
Rick Sawtell
MCT, MCSD, MCDBA|||Not quite sure exactly what you are trying to do. You can generate create
and drop table scripts using QA, and right clicking on the table itself.
If you are just trying to get column names, try this:
Select column_name from
Information_Schema.columns where table_name = 'yourTable'
Archer
"Jacques Rhéaume" wrote:

> Hi,
> I'd like to know if there is a way that I can generate a script with the
> INSERT INTO instruction of the content of the table. I know how to genera
te
> a script for the create table, drop the constraint, index, recreate the
> table, constraint... but I need to have the content of the table into that
> script. How can I do this? For the moment I do this by using a DTS that
> generate a .txt file with the content of the table, and I add manualy the
> INSERT INTO... instruction at the beginning of each row. A lost of time!
> Thank you for your help.|||> Not quite sure exactly what you are trying to do. You can generate create
> and drop table scripts using QA, and right clicking on the table itself.
Jacques is also trying to script the data in the table.