Re: metadata for Storedprocedure

I neglected to say that even those DBMSes that return a result
set/cursor
as output parameters may also return a different type of result set
depending on arguments or time of day too. Therefore they too cannot
know/report the metadata about the result set they might return.

Therefore, even if you *do* execute the procedure, and obtain the
metadata,
you have no assurance that the next time you execute the procedure,
that the metadata is the same...

Joe Weinstein at BEA Systems

.

Relevant Pages

  • Re: Security in EM
    ... you cannot hide the metadata. ... Any user in a database can execute sp_help ... (which is basically what is running behind the scenes when you click on an ...
    (microsoft.public.sqlserver.security)
  • Re: Question about attributes...
    ... Attributes allow you to place extra descriptive information into metadata ... that can be extracted using runtime reflection services. ... Attributes do not actually execute (to perform tasks like parameter checking ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Block IO question for RMS files ... Detecting EOF for empty file with deleted records...
    ... "Chris Sharman" wrote in message ... >> On an indexed file, block IO will read the metadata. ... > Depending what you want to do, you could alternatively check out Hein's ...
    (comp.os.vms)
  • Re: Any free way to create unreadable exe file yet?
    ... Indeed, you are right, the CLR needs all metadata ... ..NET Runtime still requires that *the complete metadata and IL* be ... included in an assembly before it is allowed to execute). ...
    (microsoft.public.dotnet.languages.csharp)