Using Vbscript and SQL-DMO to connect to SQL Server and run a T-SQL script
This article may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;248241
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
Quote:
> I'm trying to run a TQSL script against a SQL Server 2000 database using
> SQL-DMO and Vbscript. The output of this query would be use to populate
> a table in another SQL Server database on a different server. Has anyone
> use SQL-DMO to connect SQL Server and run a t-sql script against a
> database and use the output to populate a table on a different server?
> Any informatiom would be helpfull.
> Regards
> Magictech
> --
> Posted via http://dbforums.com