Access, Access 2000, Access 2003, Access 2003 forms, Access 2007, Access 2007 forms, Access 2007 functions, Access control, Access Database, Access forms, Access Points, Access query, Access Tables, Clustering, CSV, Database administration, Database connectivity, Database design, Database issues, Database management, Database Management Systems, Database migration, DB2, DB2 administration, DB2 Universal Database, DB2/400, DBA, DBMS, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, INSERT statement, JDBC, JOIN statement, Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access forms, Microsoft Access subforms, MySQL, MySQL Database, ODBC, QMF, Query optimization, SQL queries, Sybase, Triggers VIEW ALL TAGS
If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...