You just need to build your @Export string a little more carefully - something like this:

SET @Export = 'bcp "' + @Command + '" queryout ' + @dir + @Filename...

Have you looked in the job history for the error message?

John

I don't know what you mean. If your backup is only taking three seconds then why would you need to know what stage it's at?

John

If you use the WITH STATS option in your BACKUP DATABASE statement, you can monitor the progress of the operation.

John

If data type is float, you can't put string data in it.

John

What is the data type of your column? It would help if you could provide table DDL and sample data in the form of INSERT statements.

John

You gave the answer yourself. Drop the column and add it again with the identity property.

John

I discounted Page splits/sec because page splits are also caused by INSERT statements, and therefore if you wanted to measure the rate at which UPDATE statements cause data to be...

Not sure why you'd want to do that, but you can achieve it with a CROSS JOIN.

John

OK. Like I said, look at DATEDIFF.

John

When you say "difference time", what do you mean - the number of minutes, the number of hours, or something else? I recommend that you look at the DATEDIFF...

What have you tried so far?

John

No SQL Server error message appears to have been passed through. Is there anything in the errorlog of your SQL Server from the same time? If not, I...

Unfortunately there is no such thing as a clear solution. You need to do your own research based on your own circumstances. Noel has provided a place to...

But the answer to your question is because you have built your INSERT statement but haven't executed it.

By the way, if you must use dynamic SQL, I recommend that you...