Hello all,

I know this can be done quite easily via SPT, but for modularity purposes we need to have this as a remote view.

I can create and call the following view quite easily without any problem:


CREATE SQL VIEW "Rv_SQLDescriptionsForTable" ;
REMOTE CONNECT "SQLConn" ;
as SELECT ObjType, ObjName, Value ;
FROM ::fn_listextendedproperty('MS_Description', 'user', 'dbo', 'table', 'Order', 'Column', NULL)


This returns the SQL descriptions of all fields in the Order table. What I would like to do is pass the view a parameter for the table name, and pass that to the function. The following view fails with a no returned records error:


CREATE SQL VIEW "Rv_SQLDescriptionsForTable" ;
REMOTE CONNECT "SQLConn" ;
as SELECT ObjType, ObjName, Value ;
FROM ::fn_listextendedproperty('MS_Description', 'user', 'dbo', 'table', ?vp_Table, 'Column', NULL)


Is there any way to get this functionality with a remote view, or am I forced to use SPT here?