CREATE PROCEDURE SP_FIND_MEGA_END_USER_NAME @MegaEnvironmentName nvarchar(260), @MegaDataDbName nvarchar(260), @Session_Id nvarchar(16) AS BEGIN DECLARE @QueryText nvarchar(512) BEGIN SET NOCOUNT ON; Set @QueryText = 'SELECT DISTINCT [GBM_NAME] FROM [' + @MegaEnvironmentName + '_SystemDb].[dbo].[C_000000008000001D] WHERE [IDABS] = (SELECT [IDUSER] FROM [' + @MegaEnvironmentName + '_' + @MegaDataDbName + '].[dbo].[A_TRANSACTIONS] A INNER JOIN sys.dm_exec_connections B ON A.[IDCONNECT] = B.connection_id WHERE B.session_id = ' + @Session_Id + ' )' EXEC(@QueryText) END END; GO