Merak 9.4.2, CLSID {FBD995D1-EA68-4BD0-909D-461102F67E8F} problem

OS Version:Windows 7 64 bit

Visual Studio:Visual Studio 2010

Language:C#

Component:Merak 9.4.2

Problem:
System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {FBD995D1-EA68-4BD0-909D-461102F67E8F}


Resolution:
Compile using x86, that solved my problem for the past 3 days =)

Javascript | How to disable/enable the href functionality

Problem:
It's been a couple of days since I started solving the issue of href = "#", what I want is to disable it on certain occasion. Means there would be no active link will be shown on "Visit biboyatienza blogspot!" link, it should be display as a normal text no underline no mouse over.

From : Visit biboyatienza blogspot!


To : Visit biboyatienza blogspot!


Solution:

 var chk = document.getElementById('chkShoulBeActive');  
 if(chk != null)                 
 {  
                var hl = document.getElementById('hlSite');  
                if(hl != null)  
                {  
                     if(chk.checked)  
                          hl.addAttribute('href');  
                     else       
                          hl.removeAttribute('href');  
                }  
 }  

Hope you find it helpful

MS SQL | Enable/Disable All Database Triggers on a given Server

Problem:
A simple script that capable of enabling or disabling all databases triggers on a given Microsoft SQL Servers

Solution:

 DECLARE @Status VARCHAR(20)  
 -- Switch to enable/disable:   
 SET @Status = 'DISABLE'  
 -- SET @Status = 'ENABLE'  
 CREATE TABLE #tempTriggerToBeDeleted (RowId int IDENTITY(1,1), SqlTrigger VARCHAR(255))  
 DECLARE @dbName VARCHAR(255)  
 DECLARE @strSQL NVARCHAR(2000)  
 DECLARE ListDbs CURSOR  
 -- Insert into a temp database table:  
 FOR  
      SELECT name FROM master..sysdatabases       
 OPEN ListDbs  
 FETCH NEXT  
      FROM ListDbs  
      INTO @dbName  
 WHILE @@fetch_status = 0  
 BEGIN  
 SELECT @strSQL =   
 '  
      USE ' + @dbname + '  
      SELECT db_name()  
      INSERT INTO #tempTriggerToBeDeleted  
      SELECT   
           ''ALTER TABLE ' + @dbname + ''' + ''.'' + SU.name + ''.'' + SO2.[name] + '' '+ @Status +' TRIGGER '' + SO1.[name] AS DisableTrigger   
      FROM sysobjects SO1   
      JOIN sysobjects SO2 ON SO1.parent_obj = SO2.[id]   
      INNER JOIN syscomments Comments On SO1.id = Comments.id  
      INNER JOIN sysusers SU ON SO1.uid = SU.uid  
      WHERE SO1.xtype=''TR''  
 '  
 EXEC sp_executesql @strSQL  
 PRINT db_name()  
 FETCH NEXT  
      FROM ListDbs  
      INTO @dbName  
 END   
 CLOSE ListDbs  
 DEALLOCATE ListDbs  
 SELECT * FROM #tempTriggerToBeDeleted  
 DECLARE   
      @EndCount INT,  
      @CurrentCount INT  
 SET @EndCount = 0  
 SET @CurrentCount = 1  
 SELECT @EndCount = COUNT(RowId) FROM #tempTriggerToBeDeleted  
 WHILE @CurrentCount <= @EndCount  
 BEGIN  
      DECLARE @SqlTrigger NVARCHAR(2000)  
      SET @SqlTrigger = ''  
      SELECT TOP 1 @SqlTrigger = SqlTrigger FROM #tempTriggerToBeDeleted WHERE RowId = @CurrentCount  
      PRINT @SqlTrigger       
      EXEC sp_executeSQL @SqlTrigger  
      SET @CurrentCount = @CurrentCount + 1  
 END        
 DROP TABLE #tempTriggerToBeDeleted  
 -- Check Triggers Status on current Database:  
 /*  
 SELECT   
      T.[name] as TableName,   
      TR.[Name] as TriggerName,   
      CASE WHEN 1=OBJECTPROPERTY(TR.[id], 'ExecIsTriggerDisabled')THEN 'Disabled' ELSE 'Enabled' END AS Status   
 FROM   
      sysobjects T   
      INNER JOIN sysobjects TR on t.[ID] = TR.parent_obj   
 WHERE   
      (T.xtype = 'U' or T.XType = 'V')   
      AND (TR.xtype = 'TR') ORDER BY T.[name], TR.[name]   
 */