Memoirs Of One Techie...
Wednesday, May 18, 2011
SQL Server 2005 Jobs Fail to delete (Microsoft SQL Server, Error: 547)
After a little bit of searching around,using this phrase from the error log "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)" I was able to find a way to delete the plan, thank to this link: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/4a973abc-6675-4b5d-8c47-967ffc3679ea/ .
This specific post that solved it is:
Guys, On SQL2005, I had the same problem. Based on the previous Tips, I have cleaned up the Job Activity monitor.
Here is the steps followed.
1) Prefix the name of all the Jobs that you are having trouble deleting with 'DEL'
using Job Activity Monitor
2)
use msdb
go
-- Check whether the next Delete Statment deletes only the jobs you want to delete
select * from sysjobs where name like 'DEL%'
go
3)-- Run the following SQL to delete
delete from sysmaintplan_subplans
where job_id in(
select job_id from sysjobs where name like 'DEL%')
go
4) Go to Job Activity Monitor and Right Click to Delete Jobs
Cheers,
JamesPJ
So there it is!.. In case anyone stumbles across similar error. But I have a feeling I will need to reference this again sometime in the future.
By the way, the error was created because the sa login credential in sql is left with a blank password, hence using that authentication for the maintenance plan throws up the error. I didnt want to put a password on it to resolve the issue because I have an application that used that credential, so I ended up creating the plain with windows authentication.
Friday, March 19, 2010
Google Small Business Guide by Mashable
http://mashable.com/2010/03/19/small-business-google-apps/
Kenniy Olorunnimbe **sent from Google© Nexus One**
Sunday, November 15, 2009
My View of the World
Here is My View of The World!..I hope it make sense:
Perspective defines everything
I may see it narrow
Only because am at one side
Is it really narrow?
Tell that to one with fortune.
Its my view of the world.
And its different from yours.
The world is a beautiful place.
That though could be wrong.
'Cos what you see of her
Another man is blind
What I know for sure
Is what we want we get
Again, is that really true?
I know I want a good life
So does one torn with war
How come I get to taste some
And my brother carries gun
A part of it is human
We could be worse than beast
The bad deeds of a few
Could hold much more to will
In life we learn to love
'Cos live without love is lost
The love you have for him
Will make you show respect
How great the world could be
And peaceful for mankind
If we show the love we preach
What paradox we call money
Same as she to him
These represent the causes
Of evil man do to man
We can't have it good though
With these elements out our way
Life without them is vague!
Kenniy Olorunnimbe
**Sent from my SE X1i**
Wednesday, November 11, 2009
Seriously??no good blog tool on WinMo???
I took it for granted that there definitely should me a blog tool for windows mobile, something comparable to live writer on the desktop. I have tried a few (3 or 4), moblog and tblogger been the most recent, nothing just works right!
Guess this is another reason I need to leave the WinMo platform. I probably should think about developing that tool I have in mind..hmm..except that am not a developer. I should be developing for android when I get my next phone though (SE X10??)..
I have checked the android apps store for some blog tool, and I saw some reasonable ones, most are platform specific though. I can only imagine that the iphone OS has got a bunch too.
I guess I should just email to blogger for now. :-(
Kenniy Olorunnimbe
**Sent from my SE X1i**
Friday, October 02, 2009
Business Intelligence: Fraud Detection in a Life Insurance Company Using Data Mining..
I'v got 3 great books I am tearing into for this: Microsoft SQL Server 2008 All In One Reference For Dummies (well, am still a little bit of a dummy in this), Delivering Business Intelligence with SQL Server 2008, and Smart Business Intelligence Solutions with Microsoft SQL Server 2008. Between this great books, I just shouldn't go wrong.
I got the source database and today, I will try and identify the table so I know where the data to use are. That shouldn't be so difficult since I have full access (I think) to the original software developer and the rapport is ok. I will keep the blog posted on my progress.
First Moblog!
Friday, August 14, 2009
Word 2007 not accepting mouse/touchpad inputs, opening a blank document on open and alway closing with a crash
I had this error earlier in the day, whereby I cant seem to use the mouse/touchpad for anything on Word 2007; it just wouldnt accept any input from the device. What that means it I was only able to use the keyboard for everything I was doing. A blank document also opens when I try to open any word document on my computer and Word crashes when closed.
While I manage to just do the very urgent things I needed to do, it was not exactly easy, and very very annoying. I manage to get a fix to it (thanks to google) just when I got fed-up with the issue. I quite figure its a registry error, was able to pin it down to this key eventually:
HKEY_CURRENT_USER\Soft
Deleting that Word data key, by going to the registry (type regedit and enter from the command prompt; with administrative previlege if on Vista/Windows7) and navigating to the above key, right clicking and deleting fixed the issue.
Here is the microsoft article that supports that: http://support.microsoft.com/kb/822005/en-us
My 2cents. Have a great weekend. And I really hope I get to blog more (mean..blogging my problems and fixes alone is enough!).
Monday, September 22, 2008
Corel Draw X4 Startup Crashes?!..a working fix!!
"Hi all,
So, I bit the bullet and installed SQL server 2008 express. Sure enough, I can no longer run Draw.
Alex V. and I did some debugging and discovered that a new version
of the MFC dlls are installed (version 1833) with SQL2008. Although
Draw specifies in it's manifest that it should use version 762, it uses
the newer version instead.
Unfortunately, there seems to be a bug in the newer version of
MFC and Draw crashes whenever a docker is opened which uses Internet
Explorer control in the docker (e.g. the hints docker, concept share,
any internet docker addons (like my table styles addon)).
There doesn't seem to be any symbols for the new MFC dll, so for now, we can't debug into it.
For the time being, you can start Draw by turning off the hints docker (which is defaulted on).
Open up DrawUI.xml (you may want to back up the file) found in
<DRAW INSTALL>\Programs\UIConfig\CorelDRAW\, and find the line
<dockPage guidRef="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="true" selected="true" />
and replace with:
<dockPage guidRef="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="false" />
Similarly, in Photopaint, PPUI.xml in UIConfig\Corel PHOTO-PAINT\, find the line
<dockPage guidRef="1c56c2ec-07c1-46f0-baf7-441a555d595c" visible="true" selected="true" />
And replace with:
<dockPage guidRef="1c56c2ec-07c1-46f0-baf7-441a555d595c" visible="false" />
You'll have to run while holding F8 the first time after doing this to overwrite the old settings.
If you open up conceptshare or the hints docker, Draw/Photopaint will crash.
I'll have a bug logged and hopefully we'll be able to find a real fix for it.
Regards,
Hendrik"
As I said I got it from coreldraw.com/forum, and apparently, it was fixed by a corel employee. As indicated there, it seems to have something to do with SQL2008.