Stored Procedure in qlikview

[pooja_prabhu_n]

Hello All,

I am not able to fetch the data from the stored procedure only from the tables mentioned in screenshot below.

I am able to fetch all the other tables except 3 tables mentioned above .I am using below query to fetch the data and it is working fine for other tables.

SQL

SET NOCOUNT ON

EXECUTE [dbo].[tablename] '$(vID)' ;

Dashboard is throwing the below error:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Could not find stored procedure 'dbo.Table name'.

what does lock symbol indicates in the above picture and how to fetch data from system stored procedures.

Any suggestions on this would be helpful.

Thanks,

Pooja

[tresesco]

The padlock suggests it is encrypted. Check What is a stored procedure with a padlock icon in SQL Server 2005? - Stack Overflow You might not be able to get the data using this without the help of the DBA/developer or the owner of the same.

[pooja_prabhu_n]

Hi,

Thank you for your response.

Could you please help me in fetching the data from stored procedure into qlikview.

Thanks,

Pooja