RE: syntax to print list of SPs

From: Natesh Kumar (Kumar_at_discussions.microsoft.com)
Date: 12/10/04 

Date: Thu, 9 Dec 2004 23:53:07 -0800

Use <DataBaseName>
For Tables
select name from sysobjects where type='u'

For Stored Procedure
select name from sysobjects where type='p'

"Vyshnavi" wrote:

> Hi
>
> This query will give you the objects created by user.
> select * from sysobjects where type = 'P' and OBJECTPROPERTY ( id,
> 'ISMSShipped') = 0
>
> This query will give you the objects shipped by Microsoft during installation.
> select * from sysobjects where type = 'P' and OBJECTPROPERTY ( id,
> 'ISMSShipped') = 1
>
> Thanks
> Vyshnavi
>
> "smk23" wrote:
>
> > Could someone give me the syntax for printing the list of stored procedures
> > in a DB?
> > Thanks a lot!!
> >
> > --
> > sam

Relevant Pages

  • RE: Show dependencies of stored procedure
    ... Check this put ur procedure name in query ... Select distinct (Select Name from sysobjects one where one.id = dep.id) as ... when 'FN' then 'Scalar function' ... when 'X' then 'Extended stored procedure' ...
    (microsoft.public.sqlserver.programming)
  • Re: noise words, @@ERROR, and stop and resume indexing
    ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: ODBC query in VB code Need HELP
    ... I am trying to get a stored procedure to run on info I send it I do not need ... I played around and got the code below to work using a pass-through query, ... Dim strpass As String ...
    (microsoft.public.access.formscoding)
  • Re: slowing/halting stored procedure from ado.net
    ... calling the same stored procedure from SQL> Management ... > Studio goes without any slowdown, ... > There was/is no big job running on the sql server, ... >> Erratic performance of any query is usually due to something changing. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... Actually, what I said was "IF this code is running in a stored procedure", ... execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ... replace query 1 below with the syntax in query 2 below. ...
    (microsoft.public.sqlserver.tools)