Hi Jastin,
It works in my test.
-- SQL Server
CREATE table T1 (id int , name char (20))
EXEC sp_addextendedproperty 'MS_Description', 'MS Employee ID', 'user', dbo, 'table', 'T1', 'column', id
EXEC sp_addextendedproperty 'MS_Description', 'MS Employee Name', 'user', dbo, 'table', 'T1', 'column', name
CREATE VIEW test_fn_param ;
REMOTE CONNECT "SQLTestdb" ;
as SELECT ObjType, ObjName, Value ;
FROM ::fn_listextendedproperty('MS_Description', 'user', 'dbo', 'table', ?vp_Table, 'Column', NULL)
vp_Table = "T1"
USE test!test_fn_param
>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?
--sb--