Interesting problem at work where the wifi network printer an Epson SX420W had decided to stop working.
It seemed to be failing to find the DHCP server on our network (which is a windows server) and we'd recently bought a Buffalo WHR-G300N to act as a replacement wifi router for the office after a belkin router finally gave up the ghost.
A bit of messing around with ipconfig releasing the ip address my computer had and getting a fresh one showed that my computer couldn't get an ip address either and ipconfig came back with a timeout message as tried to communicate with the DHCP server.
So off to the router configuration page and I found a snooping option which attempts to do fancy filtering of multicast network packets (it's under Wireless config / Multicast control) turning this off meant that all of a sudden the printer appeared on the network and my computer could now get an IP address over wifi.
At least that is what I think happened (there is a chance that the router got it's knickers in a twist and all it needed was a reboot but what the heck)
Tuesday, July 26. 2011
Getting the stop words list for SQL server 2008R2
Just a quick note, to get the system list of stop words for SQL server 2008R2 for british english (change the language ID if you need other languages)
select * from sys.fulltext_system_stopwords where language_id=2057
select * from sys.fulltext_system_stopwords where language_id=2057
Friday, January 21. 2011
Is there anyone there?
Sadly I got hacked before Christmas via proFtpD (I think) and my virtual host provider took down the host, cleaned it up and I think screwed up the DB transfer (note not a complaint my fault for not backing up more often).
Since I've not been blogging that much I decided to ditch all the old content (I have older backups from more than a year ago) and like my Grumpy Dragon shaped friend Dracunculus have decided to try and put out at least a blog post a week.
Meanwhile is anyone reading this apart from spammers?....
(Page 1 of 1, totaling 3 entries)


