Linked Servers OPENQUERY Error Deferred Prepare Could Not Be Completed

I am running the following query trying to return server properties across a linked server. I want to store the results in a table on the server where I an running the query.


DECLARE @BuildClrVersionx nvarchar(128)

SET @BuildClrVersionx =

(SELECT *

FROM OPENQUERY(LKMSSQLXYZ01, 'CONVERT(nvarchar(128),SERVERPROPERTY("BuildClrVersion")'))

I am getting the following errors:

OLE DB provider "SQLNCLI" for linked server "LKMSSQLADM01" returned message "Deferred prepare could not be completed.".

Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be prepared.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'CONVERT'.


If you have any ideas how I can run this query across a linked server I would appreciate it.


Thanks,
Scott