<div>
So when you go to [DatabaseName] -- [Programmability] -- [Stored Procedures] only teh system stored procedures are showing. &nbsp;This could mean that your userid does not have permmissions to the stored procedures. &nbsp;One way would to check the user permssions at the database lvl to see what role(s) and securable level permissions are configured.
</div>


So when you go to [DatabaseName] -- [Programmability] -- [Stored Procedures] only teh system stored procedures are showing.  This could mean that your userid does not have permmissions to the stored procedures.  One way would to check the user permssions at the database lvl to see what role(s) and securable level permissions are configured.

<div>
thank guys. I got another question if you have time.<br />
<a href="https://www.experts-exchange.com/questions/27827179/sql-issue.html" rel="ugc">https://www.experts-exchange.com/questions/27827179/sql-issue.html</a>
</div>


thank guys. I got another question if you have time.
https://www.experts-exchange.com/questions/27827179/sql-issue.html [https://www.experts-exchange.com/questions/27827179/sql-issue.html]

<div>
And you are sure that database does have stored procedures?
</div>


And you are sure that database does have stored procedures?

<div>
Did any of the solutions proposed help you with this original question?
</div>


Did any of the solutions proposed help you with this original question?

<div>
<div class="content wysiwyg-content">
I use &nbsp;sql server management 2008 and try to get all the existing stored procedures.<br />
I go to stored procedure folder and only see system stored procedures...<br />
where can I view /modify all of the existing sp?
</div>
</div>


I use  sql server management 2008 and try to get all the existing stored procedures.
I go to stored procedure folder and only see system stored procedures...
where can I view /modify all of the existing sp?

sql server management tools

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,