<div>
Every database has at least 2 files, a primary file and a transaction log file, and at least one filegroup. A maximum of 32,767 files and 32,767 filegroups can be specified for each database.Log files hold all the log information that is used to recover the database. There must be at least one log file for each database, although there can be more than one.<br />
I don't recommend you try to analyze the log file, If you reaaly require to anaylze then you can use SQL Profiler.
</div>


<div>
I agree with chapmandew<br />
They got help from MS<br />
To be able to understand what's going on with the transaction log you'll need apply for a license called<br />
On-Disk Structures document
</div>


<div>
<div class="content wysiwyg-content">
When ever we create database from sql server, it's create two file. &nbsp; I want to see what's available inside the .ldf file. &nbsp;Through program (visula basic or any other way). Can you help me.<br />
<br />
i want to tranjection audit tool<br />

</div>
</div>


When ever we create database from sql server, it's create two file.   I want to see what's available inside the .ldf file.  Through program (visula basic or any other way). Can you help me.

i want to tranjection audit tool


Every database has at least 2 files, a primary file and a transaction log file, and at least one filegroup. A maximum of 32,767 files and 32,767 filegroups can be specified for each database.Log files hold all the log information that is used to recover the database. There must be at least one log file for each database, although there can be more than one.
I don&#39;t recommend you try to analyze the log file, If you reaaly require to anaylze then you can use SQL Profiler.

I agree with chapmandew
They got help from MS
To be able to understand what&#39;s going on with the transaction log you&#39;ll need apply for a license called
On-Disk Structures document

how i can read sql log file

When ever we create database from sql server, it&#39;s create two file.   I want to see what&#39;s available inside the .ldf file.  Through program (visula basic or any other way). Can you help me.

i want to tranjection audit tool


Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.