RE: SQL Querry for Homedir
Brian Johnson ( (no email) )
Wed, 10 Jun 1998 08:43:50 -0500
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Tuesday, June 09, 1998 5:46 PM
> To: emerald@iea-software.com
> Subject: Re: SQL Querry for Homedir
>
>
> 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
>
I already got this one. I was looking for something to actually create the
directory for the user. Not put the UNC in the database.
------------------------------------------
Brian Johnson
Network Administrator, Hard Drive Central
brian@hdc.net
605-229-1562 Fax: 605-229-1563
------------------------------------------