How to find which version of Ubuntu/Debian you are running

source: http://www.debianadmin.com/find-your-debian-or-ubuntu-linux-version-you-are-running.html

ou can find in different ways in ubuntu

Solution 1

cat /etc/issue

The file /etc/issue holds the version of Ubuntu installed on your system

Solution 2

lsb_release -a

or

cat /etc/lsb-release

Find Ubuntu Version Number using the Terminal

Solution 1

cat /etc/issue

The file /etc/issue holds the version of Ubuntu installed on your system

Solution 2

lsb_release -a

or

cat /etc/lsb-release

source:

Updating to Subversion 1.6 in Ubuntu 8

Here is a great blog post on how to update to subversion in Ubuntu 8, since apt-get won't update to 1.6 for you.

http://growingventuresolutions.com/blog/installing-subversion-svn-1-6-ubuntu-8-04-lts-hardy

Allow a User to Run All Stored Procedure in a Database

CREATE ROLE [db_executor] AUTHORIZATION [dbo]
GRANT EXECUTE TO db_executor

This creates a role called db_executor. Anyone given this role will be able to run all the stored procedures in the database, including new ones added after the user is given the role.


You can either give the user the executor role via SSMS or you can run this sql command against the database you want the user to have access on.

EXEC sp_addrolemember 'db_executor', [LOGIN_NAME]

For Active Directory domain names use '[domain\username]'

Turn off Identity Insert

To be able to insert a record into a table with a "hardcoded" ID you simply run:

SET IDENTITY_INSERT mytable ON

--run your insert code here

SET IDENTITY_INSERT mytable OFF

Reseed All Identity Columns in SQL Server 2005

EXEC sp_msforeachtable @command1 = 'DBCC CHECKIDENT (''?'', RESEED)'

This will get the highest record ID for each table and reset the identity seed to one number higher.

It will display any error for any table that does not have an identity column.

To do only one table you can run this:
DBCC CHECKIDENT ('tablename', RESEED)

To see what the current seed is:
DBCC CHECKIDENT ('tablename', NORESEED)

PeerGuardian Replacement PeerBlock

PeerBlock appears to be the exact same program as PeerGuardian except it installs on all windows system including 64bit w/o having to hassle with it.

http://www.peerblock.com/