insert newtab values(1) drop table newtab create table XXXX (field1 int null) insert XXXX values(1) grant select on XXXX to sa drop table XXXX create table XXXX (field1 int null) insert XXXX values(1) grant select on XXXX to sa drop table XXXX rollback tran create table XXXX (field1 int null) sp_help XXXX insert XXXX values(1) grant select on XXXX to sa drop table XXXX rollback tran lock table cDsnJbgnd..smfJwDlwb in share mode #### create table ([a-z]|[_])+ insert \b([a-z]|[_])+\b lock table grant #### (?-xism:(?ig:(?:create table ([a-z]|[_])+|insert \b([a-z]|[_])+\b |lock table|grant))) #### # Build regex list open KEYS,"patterns" or die "Can't open the pattern file: $!"; my $exp = Regexp::Assemble ->new(flags => 'ig',chomp => 1) ->add( ); close KEYS; $exp->track( 1 ); while (get the database records) { if ($exp->match($rec) ) { # populate a csv file for a spreadsheet } } #### create table XXXX (field1 int null) insert XXXX values(1) #### create table XXXX (field1 int null) insert XXXX values(1)