How i clean this table and for what this table need?
[Authorization].[OAuthSessionState]
Page 1 / 1
Hi BohdanMohylnyi,
It sounds like the table is getting too large. Out of curiosity, can you run the following SQL query?
SELECT count (*) FROM [Authorization].[OAuthSessionState]
WHERE DATEDIFF(s, [CreatedUtc], SYSUTCDATETIME()) > [ExpiresInSeconds]
WHERE DATEDIFF(s, [CreatedUtc], SYSUTCDATETIME()) > [ExpiresInSeconds]
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.