Thank you everyone for coming to the rescue! There's just so much to juggle during the holiday season that, inevitably, something falls to the ground. This year it just happened...

My tables are pretty simple:

create table table1

(

col1 int,

_when datetime default getDate()

)

create table table2

(

col1 int,

_when datetime default getDate()

)

create table table3

(

col1 varchar(10),

...

Thanks for the quick reply!

Do I need the open symmetric key and decrypt by certificate statements, like:

Bulk Insert ...

open symmetric key SOCIAL_SECURITY_NUMBER_KEY

decryption...

That makes sense. Too bad I don't have any!

Thanks a million!

John

These are wonderful recommendations!

It always amazes me how the thinking processes of the various specialties differ: as a "regular" programmer, my thinking is nitty-gritty cursor based I/O (you know, open...