Outlook Address book not update
◾Windows XP C:\Documents and Settings\%username%\Local Settings\Application Data\Microsoft\Outlook\Offline Address Books\ ◾Windows Vista, Windows 7, W...
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 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...
Posted inMSSQL
List all MsSQL DB path
Migrate前可以先了解Database位置 MsSQL 2000 select * from sysaltfiles MsSQL 2005以上 select * from sys.master_files
Posted inMSSQL
SQL 2008 還原Master
cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUN...
Hong Kong version Windows + MsSQL 2008 Error
Performance counter registry hive consistency [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\0404] 複製到 [HKEY_LOCAL_MACHINE\S...