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.

  1. Make sure SQL Server Management Studio is closed.
  2. 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.

  3. Below the EngineOptions version line, add:

    1. <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.

  4. 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    
posted @   ChuckLu  阅读(343)  评论(0编辑  收藏  举报
编辑推荐:
· 记一次.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(聚合)
点击右上角即可分享
微信分享提示