Maybe the obvious answer but you can add fields to a existing table by just
right click "design" on the table. To make it do it automatically you need
to change the odbcuser.dll.
Or you can have loads of fun with SQL triggers on the sysobjects table
(don't go there;)
Steve
Steven Moore
Internet Development Engineer
Research Machines
+44 1235 823522
-----Original Message-----
From: Mercury Internet Technical Support [mailto:[EMAIL PROTECTED]]
Sent: 07 August 2000 15:19
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/
STANDARD DISCLAIMER: This message is confidential. You should not copy it or
disclose its contents to anyone. You may use and apply the information only
for the intended purpose. Internet communications are not secure and
therefore RM does not accept legal responsibility for the contents of this
message. Any views or opinions presented are only those of the author and
not those of RM. If this email has come to you in error please delete it and
any attachments.
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/
