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...

Thank you very much ..works perfectly now !

I may need more help some other queries

thanks for that ! i'm on 2005

Although giving me an error

Msg 137, Level 15, State 2, Line 16

Must declare the scalar variable "@as_ObjectName".