Thank you for the post. I would ultimately like to have a table that shows the same fields as the view under Management, Current Activity, Process Info. The fields in particular that I would like to see User, Database, Status, Command, Application, Waiting Type, Login Time, Last Batch & Host...
Wow, that is a lot of options and thank you all for such quick responses.
The information is extremely sensitive and is only to be viewed by that particular person so passwords will have to be included.
Thank you again.
I have a pivot table that houses data for the entire corporation and it is pulling data from one large access table.
We have users that will need to only see the data for themselves and/or their department and they will need to see it in the same pivot table format.
I can do it through access...
Can anyone tell me how to link an AS400 database into a SQL 2005 server using the iSeries Access ODBC Driver? It works perfectly to link into Access 2003, but I can't get it to link and I also can't get it to import data using the DTS package. Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.