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?