How long does it take to run the sp in smss?

I doubt it takes it days to run...

All in all... post the rest of the specs :).

Yes that's what I meant. CTEs never caused me that problem...

Don't know what else to tell you. Making a new report and copying everything is easy... but...

What happens if you hit the refresh button?

The worst I saw is MS crash... but it never took hours (a couple more secs than it should have maybe, but nothing...

The only time I saw the reverse process is when there was just massive amounts of processing to do... then it made sens to export everything to desktop apps and...

Just import (like bcp in) everything on the server and process there. Now assuming it's something like insurance claims where the logic is just complexe, the cursor might be...

I'm sure it's possible... but to avoid redoing 1 year of maths or waiting for someone to redo the calculations for that constant, I'll just take the small perf hit...

Do you have ntfs permissions to delete those files?

Just do Result time 1.6. ...

2nd instance of sql server...

file not release by sql server (reboot will fix)

crappy bugs in some versions of windows like XP

file in use by AV or backup software.

... It's in the notifications tab, roughly translated from frech it should read automatically delete the job after ... (pick event from combo).

Just manually create the...

Ya, I figured as much once I saw what happened with the log restore.

I know it didn't work, but I could really explain it to someone.

Thanks for filling the...

GilaMonster (2/17/2009)

MSDB can be repaired, I believe (haven't tried it). Master I would...

Yes there is... first hit on google for ingres forumn is : http://community.ingres.com/forum/ingres-forums/