Pauls Blog

Everyone says that it's "NT SERVICE\MSSQL$[instance name] However this will not work if the objects aren't right. In Object Types, "Service Accounts" must be selected. In Locations, the local computer must be selected. Only then will it work.

declare @datet datetime; set @datet = GETDATE(); select     @datet,     cast(@datet as date),     cast(@datet as time); select     cast(cast(@datet as date) as datetime),     cast(cast(@datet as time) as datetime),     cast(cast(@datet as date) as datetime) + cast(cast(@datet as time) as datetime);

SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql ORDER BY execquery.last_execution_time DESC

netsh interface portproxy add v4tov4 listenport=81 connectport=80 connectaddress=192.168.85.30

A great article at http://wiki.centos.org/HowTos/SELinux A good command to know is chcon -Rv --type=httpd_sys_content_t /html    To see current context ls -Z 

ADSL Standard Common Name DOWN UP ADSL 1 ANSI T1.413-1998 Issue 2 ADSL 8 Mbit/s 1.0 Mbit/s ITU G.992.1 ADSL (G.DMT) 8 Mbit/s 1.0 Mbit/s ITU G.992.1 Annex A ADSL over POTS 8 Mbit/s 1.0 MBit/s ITU G.992.1 Annex B ADSL over ISDN 8 Mbit/s 1.0 MBit/s ITU G.992.2 ADSL Lite G.Lite) 1.5 Mbit/s 0.5 Mbit/s ADSL 2 ITU G.992.3/4 ADSL2 12 Mbit/s 1.0 Mbit/s ITU G.992.3/4 Annex J ADSL2 12 Mbit/s 3.5 Mbit/s ITU G.992.3/4 Annex L RE-ADSL2 5 Mbit/s 0.8 Mbit/s ADSL 2+ ITU G.992.5

Draytek Telnet Guide http://www.i-lan.net.au/downloads/Tools/TelnetCommandGuide/ All Draytek tools  http://www.i-lan.net.au/downloads/Tools/