We utilize the Bulk Admin fixed role account on our SQL 2000 servers quite a
bit. We also have some old SQL 7.0 servers though and it's been discovered
they do not have this fixed role account. How can we give a programmer
access to do the Bulk Insert function via DTS package without giving him
System Admin rights in SQL 7.0? We're in the process of trying to get these
databases migrated over to SQL 2000.

Any help is appreciated.

Thanks.

Colette Klier

IIRC you can't.

What about bcp?

Allan


"Colette" <Colette (AT) discussions (DOT) microsoft.com> wrote