Archive for October, 2007

SQL Server – How to Get the Owner of a Table

Friday, October 12th, 2007

I find the stored procedure sp_table_privileges [table name] works best.

One of the fields it returns is table owner. Yay!

Here is the full documentation for it.

Here are all my search queries:

  1. sql server find owner of table
  2. tsql + (find OR get) + object owner -change
  3. mssql find object owner

Linode IRC Link

Tuesday, October 9th, 2007

irc://irc.oftc.net:6667/linode

(I got tired of manually typing it an and wanted a nice link to take me there.)

More help

Stop your SSH Session from Timing Out

Monday, October 8th, 2007

Have you ever left your SSH connection idle for a few minutes and come back to a message like this?

root@none:~ # Read from remote host 69.91.127.167: Connection reset by peer
Connection to 69.91.127.167 closed.

Here is my attempt to fix this (On Ubuntu client and server):

On the server computer:

Set your ClientAliveInterval to a low value like 100

First back up your file:
root@none:/etc/ssh # sudo cp sshd_config sshd_config.backup

Then go into the /etc/ssh/sshd_config file with your editor of choice and add the line:
ClientAliveInterval 100
if it’s not there. Or edit that line if it’s already there.

Save the file, and restart your SSH server:
root@none:/etc/ssh # sudo /etc/init.d/ssh restart

Then close the session.

On your local (client) computer:

Set your ServerAliveInterval to 100 also.

Make a backup:
sudo cp /etc/ssh/ssh_config /ssh_config.backup

Then go into the /etc/ssh/ssh_config file with your editor of choice and add the line:
ServerAliveInterval 100
if it’s not there. Or edit that line if it’s already there.

And restart your session to server.

Mini Searches with Answers

Monday, October 8th, 2007

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Web Hosting Talk
Seems like a good place to research web hosting plans.

14.5.3 Logging to multiple destinations
How to use the Python logging module to send different levels of output to different places. E.g., console and file.

Clone Your Ubuntu installation — Ubuntu Geek
How to get a list of all your installed packages and get them installed on another computer.

DriveImage XML
An free alternative for Norton Ghost for Windows? Has anyone tried this?

TableTools :: Firefox Add-ons
A Firefox extension that lets you sort any HTML table on any webpage? Please try it out and let me know how it works. I’m terrified of trying new FF extensions myself :-(

Tags: , , , , , , , , , , , , , , , , , , , , , , ,