Ellie's blog

Linked servers cannot be used under impersonation without a mapping for the impersonated login

錯誤碼為: 0x851A0044

Replication with DB Mirroring

摘要:Replication between 2008R2 and 2012

摘要:SQL 2012 installation

摘要:Mirroring VS Log Shipping

摘要:SQL Error Log

摘要:MERGE vs. INSERT/UPDATE 效能比較

remote query timeout / 設在client 端

摘要:SQL健檢

摘要:Rebulid master 以重設伺服器collation

Subsystem % could not be loaded 或 error:c001f001

Subsystem % could not be loaded 或 error:c001f001

摘要:SQL 2000 + SP3, MSDB TargetServersRole

摘要:找出有使用某一特定物件的stored procedure, view, trigger, constraint.....

摘要:同一連接(Session)建的暫存物件都在 tempdb，故無法用 schema

Create index 與 IntelliSense 的 deadlock

摘要:列出transaction log 使用率

摘要:SQL 2005 裝 Service Pack失敗 - Error 29506

摘要:更改Maintenance Plan或SSIS package的owner