健忘症補救株式會社

在Windows 7 x64上安裝vSphere Client時,出現錯誤：

The Microsoft Visual J# 2.0 Second Edition installer returned error code 4113

[解決方式]

1.控制台->程式和功能->uninstall "Microsoft Visual J# 2.0 Redistributable Package"

2.到微軟重新下載Microsoft Visual J# 2.0 Redistributable Package, 在這裡下載

想要在SQL SERVER中的Stored Procedure中的輸出有換行的效果,

使用CHAR10 + CHAR13即可,

SET @MSG = @MSG + ' TEST LINE BREAK' + CHAR10 + CHAR13

展開linked server時,出現下列錯誤訊息：

The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource', schema 'sys'.

Solution：

USE [master]

SELECT column_A, column_B FROM db_name GROUP BY column_A, column_B HAVING COUNT(*) > 1

有一台沒上去看過的db server,因為空間不足,需要去壓縮log file,

但是查看db的Properites時,出現

Property Owner is not available for Database '[db_name]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

原因應該是這個db之前設置的owner可能是某人的AD帳號,但是那個人離職了.

在SQL SERVER 2008 R2要啟動Activity Monitor,

需在Server Name上Right click mouse -> Activity Monitor.

若是要給予某個帳號有執行Activity Monitor的權限,

SSMS UI：

建立db mirror時,出現

Error 1418

The server network address "tcp://[server name]:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

已經確定principal & mirror兩方都是相同版本的SQL SERVER,

CLR(Common Language Runtime)在SQL SERVER上預設沒開啟,

啟用clr enabled選項：

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;    --立即變更,不需等到重啟服務

Event Viewer一直持續出現：

The log shipping secondary database XXX.YYY has restore threshold of 45 minutes and is out of sync. No restore was performed for 106 minutes. Restored latency is 15 minutes. Check agent log and logshipping monitor information.

Solution：

將secondary database主機上的Windows System DateTime & TimeZone更改成跟primary database主機上的相同,

EX：

$Subject = '親愛的客戶,您好：';

$Subject = '=?UTF-8?B?'.base64_encode($Subject).'?=';    //加上這一行