Statement delimiter: ; Ignore native delimiter X Blank line i statement delimiter X Remove Trailing query delimiter TEST SETUP - OK (if run as script) IF OBJECT_ID('dbo.TestTableOne', 'U') IS NOT NULL ...

The sp_drop_create_stats_external_table is able to generate all the T-SQL statements for drop and create statistics defined on SQL Server external tables in your database! The CREATE STATISTICS ...

I'm fairly certain what you want to be using is DTS. It the wizard interface lives under Import/Export data. IMO, It's one of the best tools that has ever been designed for the computer.