[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