Posted by Madhivanan on 11/26/07 14:12

On Nov 26, 7:07 am, Boogha <boo...@gmail.com> wrote:
> I have a cursor looping through a list of tables that I want to
> truncate and then do a bulk insert into, Is this possible in SQL
> Server 2000 or do script each table individually.
>
> Cheers,
> Adam

If you want to truncate all the tables, then try this
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/truncate-all-tables-part-ii.aspx

[Back to original message]