Maybe this will help. I don't know why you want to do this. But I can think of two ways you can "impersonate" another user.

First, you can...

I would like to see how you did that. Can you post the report and a sample dataset maybe?

thanks

If I understand everything correctly, then yes I think the best way to achieve is using two tables. That's because the two datasets are at different grains.

If you want...

That's the key point, "Ultimately, it is up to management to decide where SQL resources like DBA labour hours are spent."

This is a resource assignment issue. Just calmly explain...

Thank you for posting this, Mircea. I needed something that is quick and easy to run. I appreciate it!

Thanks for the script. It's useful for me.

I don't have to worry about this because at my company we have a separate Disaster Recovery location with twin servers for all our production servers. I transfer and...

Love this topic. Great to hear all the different stories.

Graeme100, you're so right, talking about tweaking autoexec.bat and config.sys takes me back. I was a slacker teenager who...

Very helpful script. Thanks. I changed it a bit to make the code cleaner. This produces the same result:

USE MASTER

SELECT

s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name

,s.nt_domain, s.nt_user_name, c.client_net_address, c.local_net_address

--,c.connection_id,c.parent_connection_id,...

I tried exporting a Maintenance Plan to a test server so I could play around with it -- well once I renamed it on the test server, it renamed on...