• 點部落
  • 首頁
  • RSS
    • 登入

Ellie's blog

2022-06-13

sys.messages

  • 29
  • 0

SQL error code 列表

...繼續閱讀 »
2022-06-13

啟動mirroring時發生SQL Error 927

  • 29
  • 0
  • MSSQL

Database '%.*ls' cannot be opened. It is in the middle of a restore

...繼續閱讀 »
  • DB Mirroring
2022-05-31

新增Disk至SQL FCI後,無法從SSMS看見該Disk

  • 12
  • 0
  • MSSQL

新增Disk至SQL FCI後, 若無法從SSMS看見新增的Disk,有可能是Resource漏了設定Dependencies

...繼續閱讀 »
  • FCI
2022-05-27

啟用或停用WSFC 節點的投票權

  • 39
  • 0
  • MSSQL

啟用或停用WSFC 節點的投票權

...繼續閱讀 »
2022-05-27

Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server

  • 41
  • 0
  • MSSQL

若AG裡的各replica位於不同subnet,建立SQL listener遇到Error 19456

...繼續閱讀 »
2021-10-06

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

  • 53
  • 0
  • MSSQL
  • 2022-05-27

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

...繼續閱讀 »
2016-06-16

SQL 2012 SP3更新失敗

  • 120
  • 0
  • MSSQL

錯誤碼為: 0x851A0044

...繼續閱讀 »
  • 0x851A0044
2015-08-31

Replication with DB Mirroring

  • 470
  • 0
  • MSSQL

Replication with DB Mirroring

...繼續閱讀 »
  • DB Mirroring
  • Replication
2015-08-11

Replication between 2008R2 and 2012

  • 448
  • 0
  • MSSQL

摘要:Replication between 2008R2 and 2012

...繼續閱讀 »
2015-04-23

SQL 2012 installation

  • 410
  • 0

摘要:SQL 2012 installation

...繼續閱讀 »
2015-03-26

Database Mirroring vs Log Shipping

  • 674
  • 0
  • MSSQL
  • 2016-01-12

摘要:Mirroring VS Log Shipping

...繼續閱讀 »
2015-03-25

SQL Error Log

  • 680
  • 0
  • MSSQL
  • 2015-03-27

摘要:SQL Error Log

...繼續閱讀 »
2015-02-09

MERGE vs. INSERT/UPDATE 效能比較

  • 1939
  • 0
  • MSSQL

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

...繼續閱讀 »
  • INSERT/UPDATE
  • MERGE
  • performance
2014-12-18

remote query timeout

  • 468
  • 0
  • MSSQL

remote query timeout / 設在client 端

...繼續閱讀 »
  • remote query timeout
2013-10-30

SQL健檢

  • 22029
  • 0
  • MSSQL

摘要:SQL健檢

...繼續閱讀 »
  • SQL health check
2013-10-29

Rebulid master 以重設伺服器collation

  • 22532
  • 0
  • MSSQL

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

...繼續閱讀 »
  • rebulid
2013-04-29

Subsystem % could not be loaded 或 error:c001f001

  • 1753
  • 0

Subsystem % could not be loaded 或 error:c001f001

...繼續閱讀 »
  • Subsystem
  • c001f001
2013-04-29

遺失sa密碼,以single user mode重設sa密碼

  • 2900
  • 0
  • MSSQL
  • 2013-04-30

Subsystem % could not be loaded 或 error:c001f001

...繼續閱讀 »
  • 重設sa密碼
2013-01-17

SQL 2000 + SP3, MSDB TargetServersRole

  • 1136
  • 0
  • MSSQL

摘要:SQL 2000 + SP3, MSDB TargetServersRole

...繼續閱讀 »
  • failed to retrieve data for this request
  • MSDB TargetServersRole
  • SQL 2000
2013-01-07

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

  • 1864
  • 0

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

...繼續閱讀 »
  • 1
  • 2
  • 3
  • 服務規範
  • 聯絡我們
© 2022 點部落 Ver. 2022.5.5.1
電魔小鋪有限公司 製作、維運;登豐數位科技 提供資安檢測