[thelist] ADOX question

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


Ah hah, good deal.  And no problem, I had to bust out the books for that
last email so I got a refresher myself. :)

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

> Well, it looks like SQL Server doesn't fully support ADOX after all. Third
> paragraph on this site gives the basic idea:
>
>
> http://www.fawcette.com/vsm/2002_01/magazine/columns/databasedesig
> n/page2.as
> p
>
> But it does store the info I need (SP params, etc) in system tables which
> will give me some reflection capabilities into the system.
>
> Basic quick-n-dirty in EM looks like this:
>
> 	declare @id int;
> 	select @id = id from sysobjects where name = 'add_event';
> 	select * from syscolumns where id = @id;
>
> Thanks for your help though, I didn't know about the versioning thing.
>
> -dave




More information about the thelist mailing list