Hi everyone,

Has anyone got a way of telling how far a query has got when updating a
large number of rows. One of our developers is updating 22 millions
rows in one table (in a single query) and it runs for a long time. He
keeps saying that 'I can look how far it has got in Oracle' but not SQL.


Thanks
Claire
This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify the sender immediately and delete the material from any computer. Unless you are the intended recipient, you should not copy this e-mail for any purpose, or disclose its contents to any other person.
The MCPS-PRS Alliance is not responsible for the completeness or accuracy of this communication as it has been transmitted over a public network. Whilst the MCPS-PRS Alliance monitors all communications for potential viruses, we accept no responsibility for any loss or damage caused by this e-mail and the information it contains.
It is the recipient's responsibility to scan this e-mail and any attachments for viruses. Any
e-mails sent to and from the MCPS-PRS Alliance servers may be monitored for quality control and other purposes.

The MCPS-PRS Alliance Limited is a limited company registered in England under company number 03444246 whose registered office is at c/o 29-33 Berners Street, London, W1T 3AB.


MS Sql Server LazyDBA home page