The article really applies to those circumstances where someone - a developer - needs bulk insert rights, but you don't want him to become an administrator (sorry - but that was the title of the topic!). In SQL 2000 MS have recognised that this is a useful scenario and have added a Fixed Server Role for this purpose, but in SQL 7.0 my workaround is possibly the only solution.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com