Activity overview
Latest activity by SQLAdm1n
Hi Eddie,
I tried doing this a few months ago, but no luck seems something more needs to be used to get meaningful data. Best regards, Vuk
/ comments
Hi Eddie,
I tried doing this a few months ago, but no luck seems something more needs to be used to get meaningful data.Best regards,Vuk
Hi Eddie,
Thanks for picking up this post. I do understand the consequences and that it is not supported, but sometimes the login name and program name are not filled in GUI. That's why I wanted to search for the data from the repository DB. Without the login and program name, I cannot identify which application was hammering the DB (without using XE, DMVs, QS... or any other tool). Would be great if we could get this data. / comments
Hi Eddie,
Thanks for picking up this post.I do understand the consequences and that it is not supported, but sometimes the login name and program name are not filled in GUI. That's why I wanted to...
Find the program name and login name which was running the sql
Hi there, by using the CLR and code similar to the one below, I have managed to retrieve the TOP QUERIES (the same as in the RedGate Monitor tool) but I am having a hard time joining this to any ot...