found the issue. The customer gave sql server service account public role. Changed that to sysadmin. it's working fine now.

I've put the file in G drive and ran the below script:

EXECUTE master.dbo.xp_delete_file 0,N'G:\',N'bak'

I don't get any error message. It says it completed successfully, but my file is still there.;-(...

I don't see any error message in windows or sql logs. It says command completed successfully.

you can find information here:

http://msdn.microsoft.com/en-us/library/ms190920.aspx

http://msdn.microsoft.com/en-us/library/ms175835.aspx

Please post the result of Restore Filelistonly.

Any ideas anyone?

Many thanks.

Sorry Stefan.. Just been really busy with Upgrades.

Here's the feedback:

On 7 million rows:

the updates took 10 minutes with your suggestion.

Creating the indexes took about 25 minutes. So overall 35 minutes.

I...

Hi Stefan

your interpretation is correct. I have been on client site for the last two days. Will test it today when i am in the office.

Everytime a status changes it writes a record in the statushistory which then gets audited and is written in productionaudit table.

So for instance the status was 2 between '2010-05-24...

First of all, thank you for your continous help. It's much appreciated.

The question is what you want to do when there are multiple entries in the statushistory that matches the...

Yes... like I said... "accidental cross join" in the form of a many-to-many join. Any chance of you saving the execution plan as a "real" execution plan so I can...

i am struggling with this one.. I can't understand y the estimated number of rows is more than 7 millions.. When the total number of rows is 7 million for...

hi Stefan

Please find attached the table and index definations and executionplan.

After testing more i found that the method Select Into.. is quicker than disabling index and running update.

But i am following Select into for another update like below it takes...

Hi Jeff

By disabling the clustered index, won't the update statement error. If...