SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL ERROR LOG


SQL ERROR LOG

Author
Message
CANCER
CANCER
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 389
Hi,

can anyone know where the sql server stores the sql error log configuration settings info.

we want to monitor the sql error log settings so is it possible to monitor them.

By default the value is between 6-99 error logs we can have... how can we monitor them and where does it store the config setting information in like(sys table,registry etc)..

can anyone help me with this...

Thanks in advance
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5642 Visits: 1950
HVPR (11/24/2009)

can anyone know where the sql server stores the sql error log configuration settings info.

There is SQL Server error log, not aware of "sql error log configuration settings info"

Find the article below, would that help your case?

Working with SQL Server Error Logs


we want to monitor the sql error log settings so is it possible to monitor them.

By default the value is between 6-99 error logs we can have... how can we monitor them and where does it store the config setting information in like(sys table,registry etc)..


Would you like to view the error logs or view the settings? Either case, in the object explorer, under Management Node, on SQL Server Logs right click and select Configure or select View to view the Error logs.

UPDATE: Updated the link to the blog post


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
CANCER
CANCER
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 389
Hi Bru,

Thanks for the reply...

Ya I know where to look at log files but we are implementing some standards at server level.

so we are looking to write a script to monitor the sql error log setting.

if sql server error log is configured to store 6 or 20 or 30 logs..where does this info store in the system
(system table,registry etc) it should somewhere store the details right.so that we can write a script to go and get the error logs value on each server.
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5642 Visits: 1950
This should solve..

USE [master]
GO
EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'
GO




Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5642 Visits: 1950
This should solve..

USE [master]
GO
EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'
GO




Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
CANCER
CANCER
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 389
Thanks Bru,


It was very helpful to me..for getting the default value made a small change.

declare @NumErrorLogs int
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT
print @NumErrorLogs


Thanks.......
luckysql.kinda
luckysql.kinda
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1608 Visits: 659
Better use GUI instead of this query.
Attachments
ErrorLogConfig.bmp (44 views, 736.00 KB)
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5642 Visits: 1950
luckysql.kinda (11/26/2009)
Better use GUI instead of this query.

Have you read the Original Post ?

The OP wanted to monitor through script on all Server. OP has mentioned about seeing in GUI.

I had already written an article on SQL Server Error Log in my site found in my signature. I know it is can be seen in SSMS (GUI).


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
cathy.baker
cathy.baker
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1566 Visits: 396
Right Click SQL Server Agent in SSMS and select Properties.
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5642 Visits: 1950
cathy.baker (11/27/2009)
Right Click SQL Server Agent in SSMS and select Properties.


For what?


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search