發表時間 |
文章標題 |
人氣 |
2014-08-13 |
Cannot alter the user 'dbo'. (Microsoft SQL Server, Error: 15150)
|
(430) |
2013-04-30 |
Microsoft SQL Server, Error: 3729
|
(299) |
2013-03-04 |
The error message in SQL Server Configuration Manager:The remote procedure call failed.[0x800706be]
|
(94) |
2013-01-04 |
Database Suspect on SQL Server 2008 R2
|
(140) |
2012-12-27 |
SQL Server Service修改啟動帳號的密碼時出現:WMI Provider Error - Access is denied 0x80070005
|
(182) |
2012-09-03 |
Database status is Suspect in SQL Server 2000
|
(173) |
2012-08-10 |
SQL Server 2008 R2各版本的功能差異
|
(3882) |
2012-08-01 |
SQL Server Installation Center可以得知安裝資訊
|
(48) |
2012-08-01 |
判斷Table是否存在
|
(1561) |
2012-07-26 |
Error 3117 - The log or differential backup cannot be restored because no files are ready to rollforward
|
(127) |
2012-07-26 |
Error 3049 - BACKUP detected corruption in the database log
|
(131) |
2012-05-31 |
查明無法Shrink Transaction log
|
(57) |
2012-05-31 |
SQL Server Agent XPs Disabled
|
(307) |
2012-05-29 |
SQL Server Error 15138
|
(808) |
2012-05-07 |
SQL Server Agent History消失
|
(40) |
2012-03-22 |
給予一般帳號可以使用sp_who2的指令來查詢所有db的狀況
|
(325) |
2012-03-22 |
建立 .Net的Session DB
|
(31) |
2012-02-01 |
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
|
(77) |
2011-11-01 |
The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
|
(224) |
2011-08-11 |
Cannot drop the database 'XXXXXX' because it is being used for replication
|
(33) |
2011-06-24 |
The EXECUTE permission was denied on the object 'xp_prop_oledb_provider'
|
(276) |
2011-06-21 |
Property Owner is not available for Database '[db_name]'
|
(41) |
2011-06-14 |
SQL SERVER Activity Monitor & Permission
|
(178) |
2011-06-13 |
Mirror:Error 1418
|
(1670) |
2011-06-13 |
sp_configure CLR ENABLE
|
(63) |
2011-06-09 |
Log Shipping Error:Event ID 14421
|
(126) |
2011-05-26 |
出現 data access error
|
(66) |
2011-05-25 |
Grant account to exec stored procedure
|
(717) |
2011-05-13 |
Export Login to another server 將登入帳號移轉到另一台主機
|
(116) |
2011-04-28 |
Server 'XXXXXX' is not configured for RPC
|
(73) |
2011-04-25 |
移動系統資料庫
|
(33) |
2011-04-25 |
SQL SERVER 2008 R2預設沒有Sample Database了
|
(108) |
2011-04-19 |
database lock or database is in use
|
(70) |
2011-04-19 |
Replication-Replication Distribution Subsystem agent (null) failed. The publication 'xxxxxx' does not exist.
|
(44) |
2011-04-18 |
SQL Server Error: c001f011
|
(341) |
2011-04-12 |
安裝完Oracle Client之後,設置Link Server時,出現 Error: 7399
|
(901) |
2011-03-20 |
拒絕沒授權的USER使用SSMS連線
|
(129) |
2011-03-20 |
查table使用的空間
|
(53) |
2011-03-17 |
清除SSMS的Server name下拉清單
|
(109) |
2011-03-16 |
列出所有Job的名稱
|
(54) |
2011-03-16 |
Warring Message:Saving changes is not permitted
|
(58) |
2011-03-16 |
All job export to script file
|
(545) |
2011-03-16 |
ConnectionString中加入"Failover Partner"
|
(492) |
2011-03-16 |
tempdb搬移與效能最佳化
|
(1057) |
2011-03-15 |
SQL SERVER 64 bit使用link server去連線32 bit的SQL SERVER
|
(486) |
2011-03-15 |
暫存資料表
|
(547) |
2011-03-15 |
Attach/Restore 資料庫到另一台主機之後,原本的帳號密碼無法登入
|
(54) |
2011-03-02 |
安裝完資料庫之後又更改電腦名稱
|
(1941) |
2011-03-02 |
Database Mirroring
|
(123) |
2011-03-02 |
Attach MDF file
|
(905) |