不允许对系统目录进行临时更新 [英] Ad hoc updates to system catalogs are not allowed

问题描述

所以我正在尝试为一位用户手动更新哈希.我尝试更新视图，因为表不可见.

So I'm trying to manually update hash for one user. I tried updating view, as tables are not visible.

我尝试以单用户模式启动，更改sp_configure 'Allow updates',1"等，但没有成功.

I tried starting in single user mode, changing "sp_configure 'Allow updates',1", and so on, with no luck.

有什么办法吗.我不知道密码，只知道哈希值，因为从 2000 SP4 更新到 2008 R2 失败，我需要在 2008 R2 上拥有凭据，就像在旧的 2000 上一样.

Is there any way. I don't know passwords, just hashes, as updating from 2000 SP4 to 2008 R2 failed, and I need to have credentials on 2008 R2, just like on old 2000.

推荐答案

sp_Configure 'Allow Updates' 设置自 SQL Server 2005 起就没有效果，它仍然可以工作"，但不会'什么都不做.

The sp_Configure 'Allow Updates' setting has had no effect since SQL Server 2005, it will still "work" but it won't do anything.

我相信，如果您真的必须进行这些更改，您可以在实例处于单用户模式时通过 DAC(专用管理员连接)进行连接，但要小心您所做的更改:)

I believe that if you really must make these changes, you can do so by connecting through the DAC (Dedicated Administrator Connection) while the instance is in single user mode, but be careful what you change :)

如何:使用专用管理员与 SQL Server Management Studio 的连接

这篇关于不允许对系统目录进行临时更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！