Delete / Drop all stored procedures in an SQL Database

The following SQL will delete all stored procedures in a specified database.
Make sure you specify the database you are using!

USE [MyDatabase]
DECLARE @spName varchar(500)
 FOR SELECT [name] FROM sys.objects WHERE type = 'p'
 OPEN _CurCursor
 FETCH NEXT FROM _CurCursor INTO @spName
 WHILE @@fetch_status = 0
 FETCH NEXT FROM _CurCursor INTO @spName
CLOSE _CurCursor

Sorry that it lacks formatting, though it should work with just a copy and paste

Download and Use the old Windows Live Messenger 2009

Well Forgive me, I’m not normally one to rant(Ed. okay that may be a lie).But this time it’s almost serious!

Since the dawn of the blue screen, Microsoft have been royally screwing things up for the likes of you, me and everybody else.

Now they have unleashed their greatest stagnation upon the masses; Windows Live Messenger 2011 (Wave 4) . Not only has it got all the gloss of a polished turd, its got more bugs than a fisherman’s hut.  its also got a brand new terrible interface combined with the removal of some very useful features that the previous versions had.

Apart from giving me a case of the grumps..lets see what they’ve given us…

  • Tabbed conversations… We already had this with msn plus
  • A redesign of how the emoticons look how useful.
  • The ability to ignore Bing search not only from your browser, but now from within msn as well!
  • Connections to various social networks.. Okay that could be useful, but its handled in a most cumbersome way.
  • Integration with Facebook chat…Really ? why ?
  • OOOOH BADGES …erm no

Though on the flip side of the coin, here are some of the more useful things they have removed:

  • One way web cam support, you can no longer Send my web cam or View this contacts web cam instead you are forced to do some kind of Skype-esq video call which resembles half the quality of Skype but double the annoyance.
  • The abolition of contact Import/Exports.. This one really is beyond me, Why do this? okay sure i never used it.. but i could have?
  • Display names are now royally screwed up.
  • Oh yes, sorry folks, if your using anything other than Vista/Windows 7 your no longer supported.

Now you all may think I’m just a mad man ranting about a situation with no solution, a wolf crying in the wilderness? Well not exactly; There are alternatives.

For years aMSN has been developing, it is an open source alternative to the run of the mill, its free, very easy to use and works on most major platforms(Windows,MacOs,Linux etc..).

I’ve used that for awhile, but when I’m on a windows machine I still prefer the style n feel of the older msn clients…that’s why i have provided this Earlier version of Windows Live 2009.

Just un-install the latest one, via the program / features part of your control panel.

Another useful tool I use to wallow away the days is MSN plus, with polygamy( in the non marital sense) and various other tools it makes the MSN experience a bit more bearable.

A Small Update 24th Feburary 2011

Some of you may now be getting:

A newer version is available. You must install the newer version in order to continue. Would you like to do this now ?

Microsoft now deem it a requirement for you to update again to a later version, once again removing features. I am including a small replacement for the msnmsg.exe file, simply copy it into your windows live messenger directory (most likely: C:\Program Files\Windows Live\Messenger)

You will still need to install the version of Windows live messenger 2009 above.

The msnmsgr patch can be found here. Just simply replace that msnmsg.exe with the one in your Windows Live Messenger directory and all should work fine!

Happy hunting.

Beeker MSN

Dungeon Master Javascript

Could this be the height of my retro 80’s/90’s gaming obsession I hear you ask?

Well quite possibly..probably not though.

Dungeon Master Javascript is my version of the 80’s classic Dungeon Master By FTL Games.

The entire ‘game’ is written in javascript and CSS, it should be CSS2 compliant but I have used a few CSS3 methods..

You can control where you are in the maze by using the Arrow keys on your keyboard, or by clicking on the arrow icons in the interface.

The logistics of the game are quite complicated. The main premise of its functionality revolves around a 2-dimensional array of javascript objects, which divide the ‘squares’ into 5(North, East, South, West and Center) and these have a various properties too..

The visualization takes place by scanning upon movement the present location of the player/view-port in relation to the map, creating walls where it sees fit. The same goes for the doors.

This game will not work in obsolete browsers, and if it does it may be buggy..

There is no pre-loading of data at present. This means it may appear to be malfunctioning when its just loading data/graphics.

In time I hope to develop it further, however with the advent of HTML5 the methods I’m using may seem rather redundant to the modern gamer. Especially with 3d/GL developments.

I cannot take credit for the Dungeon Graphics.. they were taken from the example module of Return to Chaos…and other various old pseudo 3d games.

The source code is freely available, if you do use it though please credit/comment me 🙂