I have written several batch files to automate activities in SQL Server environment and send HTML reports over email on completion; but whenever SQL Server is down or server is unavailable then the HTML output get disturbed as no error handling is being done. When tried to write error handling to fix the issue, faced trouble as was using following code as part of an error handling,   FOR /F “tokens=1,2 delims=,” %%G in (%CD%\SQLServerList_SQLReport.txt) […]

Today got a requirement to convert an Oracle trigger to SQL Server trigger, I have not worked on DDL triggers so did a check on code, it was pretty simple and alongside used few online conversion utilities (limited freeware conversion) which helped in achieving final results.   Image Courtesy: Manageengine.com   This post is not about writing all aspects of creating triggers; it is just about resources available to help in completing conversion.   First, […]

SQL Server Agent was unable to come up and no error was being reported (only error we found as “SQL agent services started and then stopped”, nothing was logged in Event viewer as well), hence was unable to identify the actual error with which agent was failing, following is done to fix it,   1. Ran following command to read agent error log using query analyzer,                                 EXEC sys.xp_readerrorlog 0,2                 Output was: Msg 22004, […]