ADOX procedures collection & suffixes

From: Warren Mason (anonymous_at_discussions.microsoft.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 14:16:08 -0800

When I iterate (using VC++) through the procedures collection of a MS SQL 2000 server, the stored procedures are returned with a suffix of either ";0" or ";1". e.g. "mysp;1"

Can anyone tell me why this suffix is being returned and what it means? Is there a way to avoid it?

I could not find any reference to a suffix beibng returned in the ADOX help, or in the KB.

Relevant Pages

  • Re: USB device identification
    ... > suffix when you plug it in somewhere else/new. ... >> This isn't a problem where Windows just loads the drivers ... I'd be interested in an explanation of how to avoid the problem. ...
    (uk.comp.homebuilt)
  • Re: Delphi Dot Net, Better than Win32, or just Hype?
    ... I use the "Ref" suffix for anything that passes a reference to an object that shouldn't be freed. ... I find that I normally work with one primary structure that contains all the objects and then I have other objects that simply reference the contained objects. ...
    (borland.public.delphi.non-technical)
  • Custom sharepoint search for suffix
    ... Is there a way we can search in sharepoint portal by matching the ... I have documents which have reference numbers like this: ... What should I use in the where clause? ... used - correct me if am wrong please:) as it does not do suffix ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: perl one liner to remove all but the base file name
    ... && how can I get to just 'file' using a regex. ... Also I have thought about using basename with the suffix ... I cannot find a reference to it. ...
    (comp.lang.perl.misc)