Excuse me for buttin in, but:

"However, if it can change to single-user, but someone else logs in before the DBCC command starts, then the job fails, and the database does...

Maybe this helps?

Q238477

Mvg, MvG.

I think it's the "DESC" that does it, not the "-". Didn't your original posting say you wanted the rows in ASC order? In that case, you definitely need the...

Hm, well, no....

As a matter of fact settings don't match, but more important seems to be the fact that I'm using SQL7 (as stated in original posting). I'll have a...

Nope.

USE PUBS

go

alter table authors add mvgtest as substring(au_lname,1,10)

go

create index mvgIndex on Authors (mvgtest)

go

Server: Msg 1911, Level 16, State 2, Line 1

Column name 'mvgtest' does not exist in the target table.

Mvg,...

I have to react to your opinion. I can go along with the part about every table having a UNIQUE index, however, I consider it bad practice to use IDENTITY...