Issue: Cannot see a SQL Stored Procedure via the TIBCO Scribe® Insight Workbench.

You can only connect to the Scribe Internal database when the ‘Ignore Scribe metadata tables (*KSYNC) within the selected data source’ checkbox is checked.  You can only expose the Stored Procedures when the ‘Ignore Scribe metadata tables (*KSYNC) within the selected data source’ checkbox is unchecked.

To resolve this issue, create the Stored Procedures in a different database, (Not) in the Scribe Internal database.

1. Backup Database that contains the stored procedures (SPROC)  
2. Run this Script first against the database that contains the SPROC  
/*** Table: KSYNCTABLESBASE*/
create table dbo.KSYNCTABLESBASE (
    TABLENAME varchar(32) not null,
    OWNER varchar(32) not null,
    SUBJECT_AREA varchar(128) null,
    LABEL varchar(32) null,
    TYPE varchar(16) not null,
    UPDATABLE char(1) not null,
    HIDDEN char(1) not null,
    DRS_OBJECT varchar(32) null,
    BASE_TABLES varchar(254) null,
    REMARKS varchar(254) null,
    FIELD_INFO varchar(254) null,
    primary key (TABLENAME)
)
go

3. Run this script Second against the database that contain the SPROC 
/*** View: KSYNCTABLES*/
create view dbo.KSYNCTABLES
as
    select
        case when o.name is null then k.TABLENAME else o.name end as TABLENAME,
        case when u.name is null then k.OWNER else u.name end as OWNER,
        k.SUBJECT_AREA,
        k.LABEL,
        case when k.TYPE is null then o.type else k.TYPE end as TYPE,
        k.UPDATABLE,
        k.HIDDEN,
        k.DRS_OBJECT,
        k.BASE_TABLES,
        k.REMARKS,
        k.FIELD_INFO
    from dbo.sysobjects o
        join sysusers u on o.uid = u.uid
        full outer join dbo.KSYNCTABLESBASE k on o.name = k.TABLENAME and u.name = k.OWNER
    where k.TYPE = 'obj'
        or o.type = 'U'
        or o.type = 'V'
        or o.type = 'P'
go

4. Launch the TIBCO Scribe® Insight Workbench
  Click View > Check the option 'Hidden Data Objects and Fields'
5. Create a connection in the Scribe Insight Workbench to the database that contains the SPROC 
 
Reference: The scripts are located in the File ‘ScribeMetadata.sql’  which is in the Scribe folder. 

For additional information, see the following in the TIBCO Scribe® Insight Help:

• View Menu Commands
• Data Objects
• Selecting A Single Data Object As The Source