END added to the code.

In SQL 2000, I know we had to loop through users and KILL their processes. However I thought Ss2K5 would force users off after a short delay. The documentation specifies...

On the advanced tab, you can specify logging. You can also choose to have step 1 end the job if it succeeds. If it fails have it go to step...

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