Using osql log into the database osql -S SERVERNAME\INSTANCENAME -U dbusername Password: ********* 1>use dbname 2>go 1>SELECT * INTO new_target_table FROM old_source_table 2>go
Copy a Table – MSDE
read more
IT Tips
Using Knoppix and ntfsresize to enlarge a Windows XP partition
The following is useful if you have say a 10GB C: drive and it's on a larger Hard Disk and you would like to enlarge it. I don't go into the nitty gritty of using fdisk under Linux so it might be a bit abreviated if you're a newbie. Boot from Knoppix CD Once booted...
Using ImageMagick’s convert to resize all jpg’s in a directory
Using cygwin with ImageMagick installed you can resize entire directories of jpegs using the convert utility for i in `ls *.jpg`; do convert -resize 30% -quality 80 $i conv_$i; done The 30% made images with a resolution of 3072 x 2304 pixels (approx 1.6 to 2.1MB each)...
Gimp 2.4.0 is Out
Just installed it under Windows XP. Seems a lot more friendly as far as the interface goes. A good preview is located here
Changing Gnomes annoying multi-window file browse behaviour
If you don't like to open a new window (spatial mode) for each sub folder you open. Then the following change stops that behaviour and gives you the "Gnome File Browser" instead of that annoying little window (presentation mode). Open the Gnome File Browser and then...
Setup for Cross Compiling of wxWidget for Windows on Fedora 7
I haven't managed to get wxWidgets-2.8.5 to compile using MinGW and the w32 target under Fedora 7. The following was an attempt but sadly not a working one. Install MinGW Download the following from http://mirzam.it.vu.nl/mingw/packages/fc2/...
Fedora 7 – HP PSC 1610 and Xsane
I discovered you have to install hplip to getting scanning working but there are also a few dependencies that it doesn't automagically install so you need yum install hplip PyQT hplip-gui then you run /sbin/service hplip start then the setup program...
Corrupted USB Key Restoration Under GNU/Linux (Ubuntu 7.04)
Recover data from a corrupted USB Key
Fedora 7 – Amavisd Fails to Start
Nov 03 2007 Update - Amavisd again failed to start after an update same error again. This resolved the problem. I just did an yum update to Fedora 7 and rebooted seems that amavisd wasn't starting the complaint was about Compress::Zlib not loading. Long story short...
How to tell what version of Ubuntu you are running
Here are a couple of methods to determine which version of Ubuntu you are running: The contents of file:///usr/share/ubuntu-artwork/home/index.html has the "Welcome to " information. In my case that is "Welcome to Xubuntu 7.04!". The version number equates to what...