11/5/2022 0 Comments Sql server management studio icons![]() It will make sure that unwanted and unexpected issues do not occur repeatedly. In order to keep a check on server working and performance, SQL Server and Windows Logs must be viewed and checked regularly. It can be used in various scenarios like when SQL Server 2000/2005 acts up, you can search through the Log File Viewer to be your first initiative to search for the root cause of the issue. When users are registered with Management Studio SQL Server 2005, Log File viewer can be utilized with instances generated by 2000 server as it is compatible with SQL Server 2000 logs like Agent Logs, Error Logs and Windows Event Logs. Log File Viewer is available with the SQL Server 2005 but it can be used with the SQL Server 2000 instances as well. The file generated can be reviewed later by clicking “Load Log” icon in Log File Viewer for reviewing file information. In order to perform this export, click on “Export” option which will save the information of Log File Viewer to *.csv, *.log,or *.txt file. It has this “Export” functionality, which can help users to save the contents of Log file viewer for future reference. Log File Viewer provides this option to save the data displayed by it. How to Save The Data Generated in Log File Viewer? Here you can enter the exact error message in search text option and results will be generated accordingly. In order to search for a specific error message, users can click on Search button, which will open another small pop-up window with search text option. Users can also look for error message but it should be exact. This filtering can be done based on start and end date-time stamp. Here users can do the settings to fine tune data, which is being reviewed. Users can click on Filter option available in main menu, which will open another pop-up window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |