Re: SQL Querry for Homedir

Dale E. Reed Jr. ( (no email) )
Tue, 09 Jun 1998 15:45:38 -0700

Brian Johnson wrote:
>
> We moved our IIS and need a SQL querry to create all directories in the ned
> IIS directory.
> Any help would be appreciated.

Use something like this:

Update SubAccounts
Set HomeDir = '\\server\share\' + login
Where Login IS NOT NULL
and login <> ' '

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com