[thelist] ADOX question
thelist@lists.evolt.org
thelist at lists.evolt.org
Fri Oct 11 10:52:00 2002
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/databasedesign/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