So you are saying I don't have to modify this any more.

You mean, if there is one error along any path the entire package will stop ?

Cool.

Please reply

In 2005 you do not have an "Advance Options" button.

Is this tool free of charge ?

This tool is great.

Unfortunately it does not allow you to select one or few tables for scripting. ( See attached JPG file )

Our database has more than 2000 tables with...

We use 2005

Where can I find the following tool ?

SQL Server Database Publisher Wizard

Folks

Thanks, I am done.

I managed to look inside the sp_help and get the part what I wanted.

I only wanted the column definitions to go to a table. Why I wanted...

Lynn,

All right, I wouldn't mind looking at the code. how can I get the code ? Help.

Can it be

http://www.sqlservercentral.com/Forums/Topic1267687-1292-1.aspx#bm1267987

Is there anyway that you could capture the output of sp_help <table_name> to some table. You know what I mean ?

Sorry I meant

How can I empty the transaction log ?

Please see attachment. That will show the numbers

yes we do insert many millions of rows.

So what is the command that can be used to reduce the size ?

The next question if we issue this command while some...

The tempdb database is used by all other databases very heavily ? Why ? Bacause each time you make a temp table ( Those tables that start with # )...

It worked thanks

The RAISEERROR has to go inside the catch block. This is the error message I get(below).

The only thing I don't like is can this message be customized ?

I...

Wonderful idea let me try that

I need to get familiar with the raiseerror stmt. Any help with syntax