UPDATE TBDD_BASECONFIG SET DB_VERSION = '2.4.0';
GO
-- Changed 20.02.2026 Nolock
ALTER VIEW [dbo].[VWDD_USER_CLIENT] 
AS
	SELECT 
		T1.GUID AS CLIENT_ID
		,T1.CLIENT_NAME
		,T.USER_ID 
		,T2.USERNAME
	FROM 
		TBDD_CLIENT_USER T WITH (NOLOCK)
		,TBDD_CLIENT T1 WITH (NOLOCK)
		,TBDD_USER T2 WITH (NOLOCK) 
	WHERE
		T1.ACTIVE = 1
		AND T.CLIENT_ID = T1.GUID 
		AND T.USER_ID = T2.GUID 
GO