Month: March 2009

Canon Xti Flash Shoe issue…

Broke the flash shoe on my camera a couple of months ago when the camera accidentally fell and landed mainly on the flash, which caused the shoe to bend upwards at an awkward angle. I also got very expensive quotations from various repair shop. Decided to google today and find out if someone else had …

Start reading Canon Xti Flash Shoe issue…

Deleting a SQL Server maintenance plan….

If you keep getting this error: The DELETE statement conflicted with the REFERENCE constraint “FK_subplan_job_id”. The conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’. The statement has been terminated. (Microsoft SQL Server, Error: 547) RUN: (1) Use MSDB GO Delete from sysmaintplan_subplans Where subplan_name = ‘xyz’ GO If theres a reference error to sysmaintplan_log, …

Start reading Deleting a SQL Server maintenance plan….

World Community Grid…

Please join my team. African3 Current statistics: World Community Grid’s mission is to create the largest public computing grid benefiting humanity. as of 5/11/2010 World Community Grid Points = 9,056,280 Results returned = 16,351 As of 3/25/2009 World community Grid total credits = 808,331 and SETI@home credits = 103,712 5/15/2009 WorldCommunity Grid 6/20/07 – Current  …

Start reading World Community Grid…

Error: Connect to SSIS Service on machine “” failed:

On a new instalaltion of SQL Server 2008, running on Windows Server 2008, l cannot connect to SSIS from SSMS (Sql server management console) 2008 running on a client workstation. I can connect from the local server end. I tried adding the users Group to the permissions option on Component Services/MsdtsServer100 as suggested by many …

Start reading Error: Connect to SSIS Service on machine “” failed: