March 17, 2000

Contact List in Public Folder

Question: I’m looking to make an online contact list without creating a whole new ASP page for my company. I was thinking that I could simply put the Outlook contact list in a Public Folder. The only thing is, I am having trouble creating a Public Folder. Do you know

Copying Table Rows

Question: I have two databases and two tables in them have the same structure (same columns etc.). How do I copy some rows from one database to another? Both tables have the same structure. Answer: Use this: SELECT xxx from table1 INSERT into table2 WHERE blah-blah-blah

SMTP Mail Send Problem

Question: We are sending over 50K of outgoing e-mails an hour. Today the queue fills and we can only handle about 20K an hour. At some point the mail server stops accepting mail. Can you help me figure out what’s going on? I want to configure and set up a

Microsoft SQL Server 7.0 DTS and Informix

Question: I’m curious if you or anyone else has successfully created a data warehouse in SQL Server 7.0, using DTS to import/extract info from Informix, running Elite time/billing application? Answer: Haven’t seen it, but it should be workable. SQL 7.0 is a good database and has very sophisticated ROLAP analysis

Send on Behalf Of/Reply Problem

Question: If I set up a delegate and they send a message on my behalf, the reply goes to my delegate. How can I force the reply to come to me and not my delegate? Answer: There are a couple of ways that could be done: Give them “Send As”

Allow Users to Reset Your HTML Form

You can use HTML forms to provide an efficient interface for collecting user information. You can include various types of controls like textbox, check box, buttons, listbox, and so forth in your forms. While working with forms, you may want to provide functionality that allows the user to clear out