find properties triggers in sqlserver with ADO, ADOX of system tables 
Author Message
 find properties triggers in sqlserver with ADO, ADOX of system tables
Hello,

I've made some triggers in SQLServer with SQL. I have tried to read the
names and properties of these triggers with a Visual Basic program with
for example ADO, INFORMATION_SCHEMA or ADOX. I only can find the names
in the systemtable  'sysobjects'.

Is it possible to get more information from SQLServer with ADO or
something?

Thanks in advance,
Marcel

Sent via Deja.com
http://www.***.com/



Sat, 05 Jul 2003 23:16:43 GMT
 find properties triggers in sqlserver with ADO, ADOX of system tables

ADO, ADOX, etc. are nothing more than wrappers around the systems
tables (like sysobjects) and systems stored procedures/functions that
allow you a more intuitive way of getting at the information from
client applications. They're not going to tell you about anything that
isn't already there.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446/mcwtechnologies/

Quote:

>Hello,

>I've made some triggers in SQLServer with SQL. I have tried to read the
>names and properties of these triggers with a Visual Basic program with
>for example ADO, INFORMATION_SCHEMA or ADOX. I only can find the names
>in the systemtable  'sysobjects'.

>Is it possible to get more information from SQLServer with ADO or
>something?

>Thanks in advance,
>Marcel

>Sent via Deja.com
>http://www.deja.com/



Mon, 07 Jul 2003 00:14:15 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Setting Access 97 Table Column properties using ADo/ADOX

2. ADO/ADOX Table Trigger

3. Where can I found on E-book about system tables map for SQLServer 7

4. ADO or ADOX property describing the column name format of data source

5. How to extract the Caption property of MS Access columns using ADO/ADOX

6. ADOX table/columns properties reference

7. Using ADOX Catlog to modify properties of existing table

8. MS Access table properties & ADOX

9. ADO or ADOX creating a new table from a table template

10. Using ADOX to modify SQLServer 2000 tables

11. Triggers with ADO or ADOX

12. Finding Identity fields with ADO/ADOX


 
Powered by phpBB® Forum Software