Well I am a sql newbie, but I will tell you what I did. When I add the
host, I goto my sql machine and run a stored querry to setup fields. Select
Querry Analyser and create a script that adds all the required fields. Then
you cann reload this script, change the table name and instantly add them
all without omissions/errors.
I am sure there is a better way, but this works and it really takes no time
at all
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mercury
Internet Technical Support
Sent: Monday, August 07, 2000 9:19 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [IMail Forum] Extra Data in an SQL Server
Using the EZSignup utility, it adds extra user data (Name, Address, etc) to
the user's record using an ODBC connection and an SQL Update query.
But how can one add the extra fields to all the domain tables in SQL server,
and also ensure that new domain tables will be created with the extra
fields.
Alex Laderman
Technical Manager
Mercury Internet, S.L.
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/
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/
