Will you help me how to get data from schema based table
i have a table with the schema [report]
i trying to call table using openrowset like
SELECT *
FROM OPENROWSET('SQLNCLI', 'Data Source=test;Trusted_Connection=yes;Initial Catalog=PROD;Integrated Security=false;user id=sa; password=intellution;',
'SELECT * from [PROD].[report].[employee] ')
i am getting error
Msg 11529, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
The metadata could not be determined because every code path results in an error; see previous errors for some of these.
Msg 208, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
Invalid object name '[PROD].[report].[employee];
can you help me how to get data from above query