Stored Procedures Listing

I have both SQLSPService as well as Stored Procedure for database K2 Services installed in my workspace but either of them are not listing all the stored procedures present in the server in which k2 is installed. I have a custom database setup in that server for our business needs and i want to create smartobject methods based on these custom stored procedures. What am i missing??