I think this is a new attack.

Can you post the exact text? This might be a system table/area.

If you are getting errors, they are almost always hardware related. If this is a production system, I wouldn't...

If the orderdate is the correct time item, the MAX() should give you what you need.

If it doesn't, please show some data and explain what's not right.

I think they should if they will to trace code. However they should be careful not to make sysadmin type changes if they have rights.

I'd go with that advice for now. Start reading about Oracle, maybe buy a book and start learning.

Actually I think martial arts, when done at a high level, is more mental than physical. One of the reasons I got out of it years ago is that I...

I've updated the question to show partial scan with the plain yes answer and awarded back points.

Are you sure the FK is disabled? Please post some code.

Could there be another FK on the table?

A blanket rebuild isn't necessary for most tables, but it is easier to set up and I've typically run it. 8-9GB isn't a lot of space. Can you not spare...

There are some third party products to do this, and I think we have some scripts here as well.

Windows firewall?

I think access to tables does sometimes make sense, especially when there is constant ad hoc stuff happening.

However the reason it's often recommended against doing this is that it's...

Hans,

Jack has great advice. I'd avoid GOTO if possible since it tends to lead to code that can be confusing and problematic to maintain.

I'd follow the advice above for both instances.

Don't worry Lynn, we'll get through your share up in Seattle.