Camera World

Using Adobe Bridge CS4….

Heres how to add meta tags automatically to your pictures using Adobe Bridge CS4, which helps protect your photo with information relating to you the owner, no matter where the photos end up.



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)

Delete from sysmaintplan_subplans
Where subplan_name = ‘xyz’

If theres a reference error to sysmaintplan_log, first get the subplan_id
FROM [msdb].[dbo].[sysmaintplan_subplans]

then RUN:
Delete from sysmaintplan_log
Where subplan_id = ‘0805BDF5-4A25-4175-8D3E-D6B041714D30’

(above subplan_id was from my server)

Then run query #1 again.


Internet Explorer 8….

Installed this on my laptop and workstation.
I visited Wellsfargo online banking and immediately got a warning that it only supports the older browser, IE7 or Firefox 3. I could not go on further, and either have to use firefox which l have installed or re-install IE7.
Then l remembered that IE8 offers a compatibility mode, so l simply added to my list of sites under this option and bingo – it worked! l could use the banks website from IE8!


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 sites since this problem is common also in SSIS/Sql Server 2005. This didnt work.
Solution was to add the user group to the Windows Server Distributed COM Users group.
See also: Technet link