Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-27 : 23:01:10
|
Owen writes "I have an application where users pick an email name from a table. The table's original source data is an Outlook Global Address list. Using the sp_OAMethod and sp_OAGetProperty I can easily insert the email names into this table although it does take a while. The problem arises when the Address List changes - it takes roughly 2 minutes to delete the original data, use the WHILE statement to repopulate the table and then delete the special entries. The repopulation is done via SQL Agent weekly.
Is there an easier way that is faster?
DTS does not appear to offer any solution and I do not have access to the Exchange server
where the original address list resides.
SQL Server 7.0, WinNT 4.0" |
|
|
|
|
|
Rebuilding a table populated from an Outlook Address List