Koen Verbeeck (5/13/2011)

---

Nils Gustav Stråbø (5/13/2011)

---

"-Extents can be owned by only one object"

False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps...

Look up the syntax for bcp - it needs to take a query that returns a result set. ALTER INDEX does not do that. Therefore your only option...

Looks like occasional network problems are preventing your PULSE server from being reached - either that or something is wrong with the server itself.

John

If I'm understanding you correctly, I think you need to use sqlcmd instead of bcp. And take the @Command outside the inverted commas in the way that I showed.

John

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...