How do I increase the number or error logs that SQL Server keeps?
Oct 12 '09 at 01:03 PM
Steve Jones - Editor ♦♦
Oct 15 '09 at 05:42 AM
Ben Adderson ♦♦
There is a registry edit you can make, see this support article for 2000 and 2005.
Also in 2005 and 2008, there is an option in SSMS, when you right click 'SQL Server Logs' and choose Configure
Edit: links for SSMS : SQL2005, SQL2008
Oct 12 '09 at 01:28 PM
Kev Riley ♦♦
Oct 13 '09 at 05:39 AM
This link as the answer for 2005/08 - its basically a pictorial version of whats presented above http://www.mssqltips.com/tip.asp?tip=1835
Oct 13 '09 at 09:32 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 12 '09 at 01:03 PM
Seen: 1718 times
Last Updated: Oct 15 '09 at 05:42 AM
Can I tell when a stored procedure was last executed or who executed it?
Checking when the SQL Instance started
Compatibility Level Change
Good book on dynamic SQL
What are the uses of DBCC commands?
Execute a Query against multiple servers
Can I detach a filegroup?
what is MSDTC , why it is in cluster environment ?
model database transaction log growth- is that normal?
can we setup the logshipping using local account?