I was recently trying to implement a CLR function in one of my dbs. I deployed and was about to test when i got the error that CLR is not enabled in system and its required for running .NET code.…
SQL Server Agent Job issues-2
I’m continuing my experiences with managing jobs using SQL Server Agent. Couple of days back we faced a strange issue in SQL Server agent. The scenario was we trying to test run set of jobs we’ve set in QA before…
Job history listing in SQL Server agent
Recently I came across a strange issue while dealing with sql server agent. The issue was in one of our recently implemented projects which was dealing with population of data warehouse with data from heterogeneous sources. The population was done…