i have a question on this. Maybe you can help...
Following SQL works fine:
Openquery(siebeldb, 'Exec sp_help')
But when i try it on sp_helpdb:
Openquery(siebeldb, 'Exec sp_helpdb')
i get following error:
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "Exec sp_helpdb". The OLE DB provider "SQLNCLI" for linked server "siebeldb" indicates that either the object has no columns or the current user does not have permissions on that object.
Why this? I have the same permission on this object?
any idea on that?