Server Scripting to Update SQL Server Database

Server Scripting to Update SQL Server Database

Post by Dennis An » Thu, 25 Jul 2002 00:52:35



Is it possible to write some scripts on the server to update a table in SQL
Server?  If yes, do appreciate any lead?

Thanks

 
 
 

Server Scripting to Update SQL Server Database

Post by Siegfried Weber [MVP » Wed, 31 Jul 2002 01:30:32



> Is it possible to write some scripts on the server to update a table in
SQL
> Server?  If yes, do appreciate any lead?

Assuming you can access the SQL table using APIs like ADO you could build an
Exchange 5.5 Scripting Agent Script which runs server-side and fires on
several criteria. http://www.cdolive.com/agent.htm is a good start on the
Exchange 5.5 part.

--
<Cheers:Siegfried runat="server" />

Development Lead,

Microsoft Most Valuable Professional (MVP) - Exchange Server

CDOLive LLC - The Microsoft Messaging and Collaboration Application Experts
http://www.cdolive.com

Please reply to the newsgroups so that others can benefit from the
discussion.
Questions by e-mail are discarded without further notice.