I assume you are asking about DB Audit. You need to run sp_dboption to enable "bulk insert, select into" operations in the database you selected for DB Audit repository. To verify that "select/into" is enabled in the DB Audit repository (database containing the audit trail tables) run "exec sp_helpdb your_db_name_here" in ISQL. Replace your_db_name_here with the real database name. : When i try to create trigger system prompted : to run sp_dboption to set select/into rights : Even after i have set the rights i am not able : to set triggers. : Pls let me know if i am missing some steps.
|