Francisco Tapia
fhtapia at gmail.com
Tue Mar 24 12:24:10 CDT 2009
you should be able to execute any number of the Teradata's commands by issuing the command via OpenQuery It will be constructed as such: OpenQuery(LinkedServerName, 'Drop Table TableName') or what ever the command is for TeraData (sorry I am not as familiar with this engine so I cannot help). -Francisco http://sqlthis.blogspot.com | Tsql and More... On Tue, Mar 24, 2009 at 7:25 AM, Mark A Matte <markamatte at hotmail.com>wrote: > > > Hello All, > > > > I have successfully linked SQL Server2005 to Teradata. I can pull data > from...and insert records into Teradata. > > > > I have NOT been able to create or drop a table in Teradata from SQL Server. > > > > Can anyone help with syntax ( or if even possible)...or what approach??? > > > > Thanks, > > > > Mark A. Matte > > _________________________________________________________________ > Internet Explorer 8 – Now Available. Faster, safer, easier. > http://clk.atdmt.com/MRT/go/141323790/direct/01/ > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >