SQL error code 列表
2022-06-13
sys.messages
- 29
- 0
2022-06-13
啟動mirroring時發生SQL Error 927
Database '%.*ls' cannot be opened. It is in the middle of a restore
2022-05-31
新增Disk至SQL FCI後，無法從SSMS看見該Disk
新增Disk至SQL FCI後， 若無法從SSMS看見新增的Disk，有可能是Resource漏了設定Dependencies
2022-05-27
啟用或停用WSFC 節點的投票權
啟用或停用WSFC 節點的投票權
2022-05-27
Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server
若AG裡的各replica位於不同subnet，建立SQL listener遇到Error 19456
2021-10-06
Linked servers cannot be used under impersonation without a mapping for the impersonated login
Linked servers cannot be used under impersonation without a mapping for the impersonated login
2016-06-16
SQL 2012 SP3更新失敗
錯誤碼為: 0x851A0044
2015-08-31
Replication with DB Mirroring
Replication with DB Mirroring
2015-08-11
Replication between 2008R2 and 2012
摘要:Replication between 2008R2 and 2012
2015-04-23
SQL 2012 installation
- 410
- 0
摘要:SQL 2012 installation
2015-03-26
Database Mirroring vs Log Shipping
摘要:Mirroring VS Log Shipping
2015-03-25
SQL Error Log
摘要:SQL Error Log
2015-02-09
MERGE vs. INSERT/UPDATE 效能比較
摘要:MERGE vs. INSERT/UPDATE 效能比較
2014-12-18
remote query timeout
remote query timeout / 設在client 端
2013-10-30
SQL健檢
摘要:SQL健檢
2013-10-29
Rebulid master 以重設伺服器collation
摘要:Rebulid master 以重設伺服器collation
2013-04-29
Subsystem % could not be loaded 或 error:c001f001
- 1753
- 0
Subsystem % could not be loaded 或 error:c001f001
2013-04-29
遺失sa密碼，以single user mode重設sa密碼
Subsystem % could not be loaded 或 error:c001f001
2013-01-17
SQL 2000 + SP3, MSDB TargetServersRole
摘要:SQL 2000 + SP3, MSDB TargetServersRole
2013-01-07
找出有使用某一特定物件的stored procedure, view, trigger, constraint.....
- 1864
- 0
摘要:找出有使用某一特定物件的stored procedure, view, trigger, constraint.....