Following script by Ashish Jain fixed my issue 🙂

CREATE FUNCTION dbo.DistinctList

(

@List VARCHAR(MAX),

@Delim CHAR

)

RETURNS

VARCHAR(MAX)

AS

BEGIN

DECLARE @ParsedList TABLE

(

Item VARCHAR(MAX)

)

DECLARE...

Thank you guys for all valuable feedback :-)...

following Query from Mansfield working gr8 in my scenario!!

SELECTec.session_id,

connect_time,

s2.[text] as Last_Executed_SQL,

auth_scheme as Auth_Type,

client_net_address,

client_tcp_port,

es.host_name,

es.program_name,

es.login_time,

es.login_name,

ob.name as...

Thanks for the reply...actually i have following query and i want actual stored proc name instead of whole procudere on Last_executed_SQL column...

SELECT ec.session_id, connect_time,s2.[text] as Last_Executed_SQL

...

Excellent advice, since we have some monthly executing queries, i am atleast planning to observe cache for 2 months, and carefully delating, may be renaming object name will help before...