SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Select into

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Select into
Author Message
Jay Bangia



Joined: 23 Oct 2002
Posts: 1

Post Select into Reply with quote

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.

Wed Oct 23, 2002 6:57 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Select into Reply with quote

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.

Wed Oct 23, 2002 9:08 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.