> updated to point to the new location. Guess you better learn how to modify
> the DB records, pretty quick! Should not be all that hard,
> although you may
> want to export the data, use a Search and Replace in a text editor, then
> import the updated records. I'm not familiar with SQL tools so
> cannot offer
> any suggestions about a way to modify multiple records, quickly.
Tim,
If you can find your way to a SQL input in SQL Server 6.5, enter this query
(after making a backup of your db, of course):
UPDATE domain_com
SET userdir = 'D:\domainDirectory\users\' + userid
WHERE userid = userid
This will replace the userdir column value for every row in the table.
Notes: "domain_com" should match your table name. "D:\domainDirectory"
should be wherever you moved your top directory for the domain in question.
If the query throws an error on the "+" concatenator, try "||" (two pipe
characters) instead, which is the ANSI standard for string concatenations...
but since SQL Server 7 throws an error on the pipes, I'm guessing SQL Server
6.5 will like the "+" better, too.
Hope this helps,
Ron
ron allen hornbaker humankind systems, inc. mailto:[EMAIL PROTECTED]
HKSI WebMail Templates for IMail v6x ~ Now 888 Installations Worldwide
Classic... http://mail.hksi.net Killer... http://killerwebmail.com
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
