Re: New Web Server

Dale E. Reed Jr. ( (no email) )
Tue, 23 Dec 1997 14:15:55 -0800

Jason Powell wrote:
>
> We are changing to a new web server. Soooo I need to change the home
> dir on all my users from
>
> \\mind1\www\username
>
> to
>
> \\ns1\www\username
>
> Does anyone know a SQL command I could run to get this automated?
> Thanks for the help

You can use something like this:

Update SubAccounts
Set HomeDir = '\\ns1\www\' + login
Where HomeDir is not null

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