Posted inActive Directory Exchange Windows
Windows 2008 R2 + Exchange 2010
ServerManagerCmd -ip D:\Scripts\Exchange-Typical.xml -Restart Set-Service NetTcpPortSharing -StartupType Automatic http://go.microsoft.com/fwlink/?Lin...
Posted inMSSQL
SQL statement
select 產品名稱,單價,單價+30 from 產品 select 產品名稱,單價,單價-20 from 產品 select 產品名稱,單價,單價*1.15 from 產品 select 產品名稱,單天產量,單天產量/3 from 產品 select 產品名稱,單天產量,單天產量/3,單天產量%...
Posted inMSSQL
SQL 2000 還原bak及master.bak
net stop MSSQLSERVER C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -m osql -S localhost -E Password: 1)restore database master from di...
Posted inLinux
OpenMediaVault Module iscsi_trgt not found
Version : OpenMediaVault 1.9 x64 # apt-get purge iscsitarget # apt-get autoremove # apt-get clean # apt-get install linux-headers-$(uname -r) build-es...
Huawei STP
POE for CCTV LSW7 G0/0/2 - LSW6 G0/0/2及LSW1 G0/0/1 - LSW2 G0/0/1為後備 LSW5 stp root primary LSW8 stp root secondary LSW1 int g0/0/1 stp cost 100 LSW6 in...
Zimbra 8.6.0 on Ubuntu 14.04 LTS
apt-get update apt-get upgrade apt-get install libperl5.18 libaio1 unzip pax sysstat sqlite3 wget https://files.zimbra.com/downloads/8.6.0_GA/zcs-8.6....
Elastix 2.4 on RASPBERRY PI
Reference: http://www.uelastix.com/ NOT WORK!! wget http://liquidtelecom.dl.sourceforge.net/project/elastix/Elastix%20PBX%20Appliance%20Software/2.4.0...
Posted inMSSQL
啟動Database Mail Error
無法在資料庫 msdb 中啟用 Service Broker，因為資料庫 (x) 中的 Service Broker GUID 與 sys.databases (x) 中的不相符。 use master go alter database msdb set single_user with roll...
Posted inActive Directory Windows
Use GPO change Local User Name and Password
Microsoft 2014年中公報用GPO改Local User Account呢個功能有安全問題, 但好像一直未有解決方法, 暫時發現以下3個Patch都會Disable Password位置, 因為需要這個功能, 所以我都暫時性Uninstall以下3個Patch KB2928120, KB3...