[thelist] ADOX question

David.Cantrell at Gunter.AF.mil David.Cantrell at Gunter.AF.mil
Fri Oct 11 10:52:00 CDT 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



More information about the thelist mailing list