0）停掉你現有的資料庫服務.
1）新建一個實例,就是重新安裝一次sql server,以下稱為new
2）把你舊的資料庫實例（以下稱為old）的master.mdf , master.ldf copy到一個文件夾
3) 在new中,通過attach db的方式把文件夾中的兩個文件加為new中的資料庫,當然名稱和位置在添加的時候都要改的.
4）在new 中,通過語句的方式,把master中的表sysxlogins 中sa的密碼更新到你剛添加的資料庫（old中的master）的表sysxlogins中對應的sa 的密碼欄位.
5）把你剛添加的資料庫（old中的master）在new中detachdb,然後把文件覆蓋掉old中對應文件（覆蓋前把文件備份）
6）重新啟動old伺服器,看是否可行
7）卸載new伺服器
[url]http://www.mssqlcity.com/FAQ/Trouble/error_259.htm[/url]
[url]http://www.mssqlcity.com/FAQ/Devel/AmendSysTb.htm[/url]
How can I resolve the error 259?
Answer:
This is the error 259 message text:
--------------------------------------------------------------------------------
Ad hoc updates to system catalogs are not enabled. The system administrator
must reconfigure SQL Server to allow this.
--------------------------------------------------------------------------------
You will get the error 259 when you tried to modify the system catalogs directly while the allow updates system configuration option is set to 0. To work around the error 259, you should set the allow updates option to 1 by using the sp_configure system stored procedure.
Check this link for more details:
How can I edit the system tables manually?
How can I edit the system tables manually?
--------------------------------------------------------------------------------
Answer:
It is not recommended to do, but it is possible. You should set the allow updates option to 1 by using the sp_configure system stored procedure.
This is the example:
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
Read about the sp_configure system stored procedure in SQL Server Books Online
Code:
--------------------------------------------------------------------------------
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
--------------------------------------------------------------------------------
use master_old
update sysxlogins set password=NULL where name='sa'
select name,password from sysxlogins
