What you are suggesting won't achieve the same result. If the tran backup is done at 9am today for example, the load/restore won't happen until next day at 9am. That...

The files are successfully copied and there is enough delay for the restore to begin. The load is delayed for 15 minutes. These responses bear no relevance to my question.

...

On this issue of index, what are the implications of having duplicate indexes. I have some on my inherited server and I want to gwet rid of the duplicates.

However, I...

Thanks all. rascota's suggestion seems short and gets the job done.

Check this web site for all the information you need:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/support/sql/content/2000papers/LogShippingFinal.asp

The above should be a single line string.

data czar: The UNION has been tried before but did not work.

cliffb: Your idea is interesting and will be tried. I have done something on this line before but did...

when restoring the TLog you need to choose the third radio button on the Options page.

That will solve the problem.

You may also use rebuildm tool provided by Microsoft. Look in BOL on how to use it. This will help take care of the server and the tempdb but you...

Thanks for your help.

solutions 1 and 3 will be my best bet. Can you give me examples of how these can be done?

Thanks.

I think the problem in QA is setting the option to have column aligned in the result tab.

Thanks for your response.

My select statements have different number of columns. Copying the data to a temp table is likely to be a pain.

I am having the same problem and will appreciate any ideas.

I notice that the BCP works only for a query or SP that conatins a single select statement. That is,...

Thanks for the tip about dragging the columns, it's a nice one.

I have however resolved the bug problem by using exec('insert into tableA select * from tableB'). It worked just...

What do you do if you have 50 columns in a table?. There must be a better way of doing this.

by the way this query is contained in a stored...