RE: syntax to print list of SPs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vyshnavi (Vyshnavi_at_discussions.microsoft.com)
Date: 12/09/04 

Date: Wed, 8 Dec 2004 22:15:02 -0800

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: sfc / scannow asks for Windows CD--I dont have one! What to
    ... There are spaces between Reg and Query, Query and HKLM, ... to find out if this kit includes a genuine XP installation CD. ... Nepatsfan ... Scholastica wrote: ...
    (microsoft.public.windowsxp.perform_maintain)
  • SQL Compact Edition does not recognize parameter
    ... The query and the ... assured that all computers have the same installation. ... It's always the same error message althought there are 35 parameters ... Only the hardware is different but on one PDA the problem exists ...
    (microsoft.public.sqlserver.ce)
  • [Info-ingres] Re: Weird Optimizer Error
    ... I've gone so far as to convert the installation from an SQL- ... I've now managed to use trace point sc924 to identify the query causing ... The table has an isam secondary index that reverses this key, ... I've set query auditing on for the user who executes the application that ...
    (comp.databases.ingres)
  • Re: SQL Compact Edition does not recognize parameter
    ... you might try looking in the debugger to see what the parameters collection looks like before you execute the query. ... assured that all computers have the same installation. ... It's always the same error message althought there are 35 parameters ... Only the hardware is different but on one PDA the problem exists ...
    (microsoft.public.sqlserver.ce)
  • Re: Access 2002 Report Wizard problem
    ... Maybe they just didn't fix the Report Wizard working with the Justified layout? ... I've narrowed it down to a simple test case: A query just pulls two simple fields from a simple table; ... Or is it just my installation? ...
    (microsoft.public.access.reports)