Re: [IMail Forum] Extra Data in an SQL Server

[Mercury Internet Technical Support]

pffuuu changin the .dll, a bit of a pain....

running extra scripts everytime you add a host, bit of a pain too..

maybe, if we modif the ASP in HKSI's pages to add the extra data to another
database?� an only add the userid, password etc to the main user DB.?�?
wouldn't that be a better solution?�'

Alex Laderman
Technical Manager
Mercury Internet, S.L.


----- Original Message -----
From: STEVEN MOORE (IFL) <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 07, 2000 5:31 PM
Subject: RE: [IMail Forum] Extra Data in an SQL Server


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/


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/