RG_SQLSourceControl_DDLTrigger

Msg 15404, Level 16, State 19, Procedure RG_SQLSourceControl_DDLTrigger, Line 0 [Batch Start Line 0]
Could not obtain information about Windows NT group/user 'AMTRUSTSERVICES\BBrown1', error code 0x6ba.

Hello Redgate

We're getting this error come up on a development server (it happens on any DDL statement like creating temp table or altering SP). I haven't used sql source control for quite a few months when I demo'd it to the team. I demo'd locks on objects but cleared them all. the lock table is empty inside the Redgate database.

any ideas as to what I can do?

cheers
Ben

ben_b October 30, 2018 11:15

Comments

3 comments

If you're not using Object Locking, you can just drop the trigger. See https://documentation.red-gate.com/soc6/common-tasks/lock-an-object/remove-object-locking

Mike U October 30, 2018 11:53

0
cheers Mike - I believe this has worked!! I don't work too much with triggers, do you know why I wasn't able to find the objects through SSMS / SQL Search?

ben_b October 30, 2018 14:47

0
ah ok - I just realised it was at Server Level. Server>>Server Objects>>Triggers. Cheers!

ben_b October 30, 2018 14:54

0

Add comment

Please sign in to leave a comment.

How can we help you today?

RG_SQLSourceControl_DDLTrigger

Comments

Add comment