Browsing articles from "April, 2013"
Apr
30
2013

Write a Batch (.bat) file error handler for SQL instance down when fetching details from several SQL Servers

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) […]

Apr
30
2013

Oracle to SQL Server Trigger Migration – Useful Tips

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, […]

Apr
16
2013

Fix: Issue with SQL Agent not coming up due to agent error log path incorrect

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, […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

April 2013
M T W T F S S
« Mar   May »
1234567
891011121314
15161718192021
22232425262728
2930  

View Post by Categories

%d bloggers like this: