Login using osql Windows Auth osql -E SQL Auth osql -U sa List databases 1>sp_databases 2>go To list the tables in a database 1>use dbname 2>go 1>sp_tables 2>go To show the table structure 1>use dbname 2>go 1>sp_help table_name 2>go Attach a DB exec sp_attach_db...
Problem: looking in /var/log/cups/error_log E [28/Oct/2008:10:26:03 +1100] PID 6548 (/usr/lib/cups/filter/foomatic-rip) stopped with status 2! E [28/Oct/2008:10:26:04 +1100] [Job 13] Job stopped due to filter errors. Cause: I think this was caused by me running sudo...
So I installed the development version of the upcoming Ubuntu 8.10 and thought this is great, but when it came time to drill down to actually using it I ran into the following. Network Manager PPTP client connects but builds tunnel which allows ping and smb to pass...
Suppose you have the following configuration Priv Network A---Windows XP Clients | Linux gateway (iptables NAT etc) | [Internet] | Linux gateway (iptables GRE and PPTP port 1723 NAT'd and forwarded to internal PPTP server) | Priv Network B---<linux PPTP Server>...
I went to Openoffice.org and blindly downloaded the default package "OOo_3.0.0_LinuxIntel_install_wJRE_en-US.tar.gz" which is the wrong package for Ubuntu 8.10. The Fix: Go back to openoffice.org, under "I want to download OpenOffice.org" click the "Get more platforms...
I'm putting this here so I can use it for later. I have the following: 150GB HDD of which 123GB is filled with data on a Dell Optiplex 330 the source computer 1TB Western Digital MyBook Essential Edition as the backup media A copy of the latest Ghost Corporate Edition...
wget has a cool feature known as limit-rate. If you want to leave a bit of bandwidth for other things then use it with double u get. wget -c -t 100 --limit-rate=80k http://ftp.iinet.net.au/pub/ubuntu-releases/8.10/ubuntu-8.10-beta-desktop-i386.iso The above means -c...
I had a virus infested computer and I wanted to zero the partition and restore from a partimage file but first I thought I would zero out the data on the partition using dd so: dd if=/dev/zero of=/dev/hda1 This took absolutely ages... and I was wondering when it was...
You get this error when trying to umount a partition: umount /mnt/sdb1/ umount: /mnt/sdb1: device is busy umount: /mnt/sdb1: device is busy At a root prompt: Run fuser see man fuser for options fuser -v /mnt/sdb1/ Output of fuser USER PID ACCESS COMMAND...
Problem: Cause: Fedora isn't as good as Ubuntu at detecting and installing your devices Resolution: Install libsane-hpaio Done