SQL Server hides a lot of very useful information in its error log files. Unfortunately, the process of hunting through all these logs, file-by-file, server-by-server, can cause a problem. Rodney Landrum offers a solution which will allow you to pull error log records from multiple servers into a central database, for analysis and reporting with T-SQL.
2010-04-28
2,955 reads
2009-10-09 (first published: 2009-09-29)
2,035 reads
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
3,332 reads
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
2,211 reads
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
2009-08-04
9,976 reads
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
2009-06-26
12,546 reads
SQL Server doesn't come with very good tools to do this....If the database(s) is not too large you could script out the DB structure (generate SQL script, including the create DB statements...under Options) and then make a backup of the source DB. Then, burn a copy of the resulting .bak file onto some media and then move to […]
2005-01-07
If the in-house users are not having any problems, I would first verify if the "timeouts" the remote users are getting are truly Access timeouts. Try to replicate the error over your own VPN connection. If they are using the app via Citrix over a VPN, then I would ask how 'close; is your app to the […]
2005-01-07
2004-12-16
Hehe, I enjoyed this discussion. Now, if I were to develop this from the start, I wouldn't use VB6 anymore. Not sure, if I would use VB.Net. I think I would use either C# or MVC++ (yuk, yes). But as AJ said, this is VB6 and it is a relikt. I don't want to put more […]
2004-12-14
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers