Master, MSDB, and TempDB are defaulted to "Simple" recovery.  Master can be changed to Full Recovery and then I think you can do a transaction log backup.  Not 100% sure, though.

Thanks, Mark... it takes DOS-like wildcards (*) as well...

Have BCP do a Queryout from a sproc or a view that does a union between some column names and data... keep in mind that all of the data must...

Perhaps it's just a language barrier problem... but, if it's not, I agree with Serqiy... why would you need to count the number of columns present in a table?

In our case, the term "clone" would be more appropriate.  Not sure how it works, but it just takes a couple of minutes everynight on a tera-byte database.  Has something...

How does that produce the dynamic sizing the OP asked for? That code works great on the input but does nothing for formatting the output in the text window.

Michaeal said it right...

There's too many tables being updated, so a trigger is out.

Write a sproc to generate the trigger code...

It would be good if you posted one of the offending lines of code (sans password)... there's lot's of options in BCP...

Good golly, folks... open Query Analyzer and press {f4}....

This probably doesn't help, but the right way to do it would be to deny all users the ability to create procs and to follow a code promotion process.

Thanks for taking the time for the explanation, Rog...

But... being able to pass tables to stored procedures, with the understanding that you will have multiple tables with the same...

Let us know what you finally come up with so that others may learn, as well.

Heh... did you try it?

http://www.sql-tutorial.net/

http://www.firstsql.com/tutor.htm

When you get done being a newbie, then practice answering question on this forum as Serqiy suggested.  You also may want to take a peek at...

http://www.nigelrivett.net/

Remember...