You have first map the user to corresponding login inorder to get access on database. specify the databse role in to the user.

This query will help to you.

select

r.session_id,

r.request_id,

max(isnull(exec_context_id, 0)) as number_of_workers,

r.sql_handle,...

Use OPENDATASOURCE feature.

SELECT *FROM OPENDATASOURCE('SQLNCLI',

'Data Source=Server2;Integrated Security=SSPI')

.test.dbo.MyTable

This article may help you digout.

http://www.simple-talk.com/community/forums/thread/1439.aspx

its like you are not getting any result after firing above query?

check the cpu or physical IO is moving or not of that spid which is in killed\rollback state ?