Object changed by Unknown
https://documentation.red-gate.com/soc7/troubleshooting/object-changed-by-unknown
https://documentation.red-gate.com/soc7/configuring/log-changes-to-shared-databases
Step 1: Creating the change log database
You can use this SQL script template to create a dedicated change log database named ChangeLog
. You can modify the script as needed.
USE master EXECUTE ('CREATE DATABASE ChangeLog') ALTER DATABASE ChangeLog SET ANSI_NULL_DEFAULT OFF ALTER DATABASE ChangeLog SET ANSI_NULLS OFF ALTER DATABASE ChangeLog SET ANSI_PADDING OFF ALTER DATABASE ChangeLog SET ANSI_WARNINGS OFF ALTER DATABASE ChangeLog SET ARITHABORT OFF ALTER DATABASE ChangeLog SET AUTO_CLOSE OFF ALTER DATABASE ChangeLog SET AUTO_CREATE_STATISTICS ON ALTER DATABASE ChangeLog SET AUTO_SHRINK OFF ALTER DATABASE ChangeLog SET AUTO_UPDATE_STATISTICS ON ALTER DATABASE ChangeLog SET READ_WRITE ALTER DATABASE ChangeLog SET RECOVERY SIMPLE ALTER DATABASE ChangeLog SET MULTI_USER ALTER DATABASE ChangeLog SET PAGE_VERIFY CHECKSUM ALTER DATABASE ChangeLog SET DB_CHAINING ON EXECUTE ('USE ChangeLog IF NOT EXISTS (SELECT * FROM sys.sysusers WHERE name=''guest'') EXECUTE sp_grantdbaccess guest')
Step 2: Editing the config file
After the change log database is created, you need to edit a local config file so SQL Source Control can access it.
- Make sure SQL Server Management Studio is closed.
-
Go to the SQL Source Control config files folder: %localappdata%\Red Gate\SQL Source Control 7
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor. -
Below the
EngineOptions version
line, add:- <TraceCacheDatabase>ChangeLog</TraceCacheDatabase>
The file is case sensitive. Don't change the capitalization of the text.
Ignoring any comments (indicated with
<!->
), the final file should look like this::ExampleToggle source code
The example above doesn't include any extra lines you may have included for other options.
- Save and close the file.
SQL Source Control will now use the change log database to log changes made to all linked databases.
<EngineOptions version="3" type="EngineOptions" > <TraceCacheDatabase>ChangeLog</TraceCacheDatabase> </EngineOptions>
SELECT DB_NAME(DatabaseID) AS DatabaseName, UserName, * FROM dbo.RG_AllObjects_v4 WHERE UserName IS NOT NULL AND DB_NAME(DatabaseID) LIKE '%UK%' ORDER BY EntryDateTime DESC;
作者:Chuck Lu GitHub |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 全程不用写代码,我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2018-12-04 read appSettings in configuration file by XElement with xmlns
2018-12-04 get all sites under IIS
2017-12-04 cache
2017-12-04 gridview in webform
2015-12-04 Lists of network protocols
2015-12-04 websocket
2014-12-04 Git的fast forward和no fast forward和 three way merge 以及squash(聚合)