Could anyone shed some light on the syntax of accessing system function on a linked server?
I'm trying to get the recovery models of databases on a linked. However using databasepropertyex locally generates wrong results.
e.g.
select databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases
I tried select [server/databasename].databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases
which does not work.
Thanks.
No comments:
Post a Comment