Actually it doesn't work as it lists back all linked servers on the specific server 🙁

I just need the server where i'm receiving the info from...

thanks

This will work I guess , although I would like the column at the beginning...

SELECT

distinct A.login_name Login, A.host_name 'Originating HostName',

DB_NAME(B.Database_ID) DBName, B.command,

A.program_name,

data_source as 'Linked Server Name'

FROM [linked].master.sys.dm_exec_sessions A

...

Thanks for response... I found the fix and it was by logging in with a SQL login and NOT windows login. Not sure why but everything worked including updates towards...

UPDATE: I've clicked on the provider dynamic parameter and now get this error when querying the Oracle DB.

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for...

Steve Jones - SSC Editor (5/23/2012)

---

Note that when you write this, store the data, but don't report "success" to yourself on a regular basis. It's easy to start ignoring the...

The second script does work well with the required info ...but and like I said I would need that column with a status message 🙁

I can't seem to produce the...

OK I got the script to work by changing and commenting ! Thank you

Pardon my ignorance...

I still cannot get a column with a 'SUCCESS' or 'FAILED' to show up 🙂

Thank you for the script ...

Although I'm not getting any output ?

I just want to return the results of all databases on the server.

Thanks for that... good write up

Thanks Gianluca 🙂

just one more question ... in the output , the database column only show the 'master' DB for some rows and nothing for the rest of the databases in...

thanks for that...

That's strange.... thanks anyways for the tips, much appreciated.

I've actually tried that 2nd script but it doesn't return anyone with either server permission even when commenting the

WHERE server_principals.type IN ( 'S', 'U', 'G' )

, is...

I need more help in determining more server level permissions

1- list of users that have the 'ALTER SETTINGS' level permission

2- list of users that have the 'CONTROL SERVER' level permission

Any...