Interested to Buy Any Domain ? << Click Here >> for more details...
What are mdf,ndf,ldf files and how to see the data in those
files?
- 6 Answers
- 59928 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / arunyadav007
For reading the log files (.ldf) an undocumented system
stored procedure sp_readerrorlog is there. This SP allows
you to read the contents of the SQL Server error log files
directly from a query window and also allows you to search
for certain keywords when reading the error file. This is
not new to SQL Server 2005, but this tip discusses how this
works for SQL Server 2005.
This is a sample of the stored procedure for SQL Server
2005. You will see that when this gets called it calls an
extended stored procedure xp_readerrorlog.
This procedure takes four parameters:
Value of error log file you want to read: 0 = current, 1 =
Archive #1, 2 = Archive #2, etc...
Log file type: 1 or NULL = error log, 2 = SQL Agent log
Search string 1: String one you want to search for
Search string 2: String two you want to search for to
further refine the results
If you do not pass any parameters this will return the
contents of the current error log.
Example 1
EXEC sp_readerrorlog 6
This statement returns all of the rows from the 6th
archived error log.
Example 2
EXEC sp_readerrorlog 6, 1, '2005'
This returns just 8 rows wherever the value 2005 appears.
Example 3
EXEC sp_readerrorlog 6, 1, '2005', 'exec'
This returns only rows where the value '2005' and 'exec'
exist.
Even though sp_readerrolog accepts only 4 parameters, the
extended stored procedure accepts at least 7 parameters.
If this extended stored procedure is called directly the
parameters are as follows:
Value of error log file you want to read: 0 = current, 1 =
Archive #1, 2 = Archive #2, etc...
Log file type: 1 or NULL = error log, 2 = SQL Agent log
Search string 1: String one you want to search for
Search string 2: String two you want to search for to
further refine the results
?
?
Sort order for results: N'asc' = ascending, N'desc' =
descending
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
How is SQL Azure different than SQL server?
Why the trigger fires multiple times in single login?
What is the definition for sql server 2000?
What is model database? : SQL Server Architecture
Tell me what is difference between view and materialized view?
What is a transaction and why is it important?
how can you attach more than 20 ldf files in sql server
What is primary key, unique key, and foreign key?
What are the properties of the transaction?
What does ss stand for sexually?
Where is localdb stored?
Can we do dml on views?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Define a cross join?
How you trouble shoot when any job fails
