[thelist] ADOX question

Chris Blessing webguy at mail.rit.edu
Fri Oct 11 09:41:01 CDT 2002


Dave,

IIRC the ;1 is how SP versions are denoted.  You can have multiple versions
of the same stored proc with this.  So:

add_event;1 is the 1st version of the add_event sp.  You could also have an
add_event;2 and ;3 and so-on.  How did you create these stored procs?

Sorry I can't help ya with the Procedure properties issues.

HTH!

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> I am tinkering with ADOX in ASP, and was wondering if anybody knows why my
> stored procedure names all have ";1" appended to them?
>
> For instance, all procedure names look like this:
>
> 	add_event;1
> 	get_eventbyid;1
> 	add_feed;1
> 	...
>
> I am using SQL Server 2000 as the provider, ADO 2.7 on the server.
>
> I haven't seen this in any of the docs or tutorials I've read so far. :(
>
> Also, I'm getting empty values for Procedure.DateCreated and
> Procedure.DateModified. The MSDN docs say the Procedure object supports
> DateCreated and DateModified, but the value is Null if the
> provider doesn't
> support this. I'm having trouble believing SQL Server 2000 doesn't support
> Microsoft's own properties...
>
> Thanks!
> -dave




More information about the thelist mailing list