this type of principal cannot be impersonated, or youdo not have permission

Symptoms: GGSCI> delete trandata dbo.* 2020-12-08 11:53:54 WARNING OGG-00782 Error in changing transaction logging for table: dbo.tab. 2020-12-08 11:53:54 ERROR OGG-05345 Failed to disable change data capture for table ‘dbo.tab in the database ‘tstdb’. SQL error: 15517: [Microsoft][ SQL Server Native Client 11.0][SQL Server]Cannot execute as the database principal because the principal “cdc” does not […]

SQL Server Commands

–Performance tracking sp_who2 65 DBCC opentran() dbcc inputbuffer(71) DECLARE @Spid TABLE ( SIID VARCHAR (MAX), [Status] VARCHAR(MAX), [Login] VARCHAR(MAX), HostName VARCHAR(MAX), BlkBy VARCHAR (MAX), DBName VARCHAR(MAX), COMMAND NVARCHAR(MAX), CPUTime INT, DiskIO INT, LastBatch VARCHAR(MAX), ProgramName NVARCHAR(MAX), SPID VARCHAR (MAX), REQUESTID VARCHAR (MAX) ) INSERT INTO @Spid EXEC sp_who2 SELECT * FROM @Spid — Filter by […]