This isn't "locking" a row or cell. a lock is preventing an update from colliding with another, not preventing someone from being able to update. That's a permissions issue.

What you...

Not sure that z: is a network drive. We standardized on z: for our servers years ago as the data drive for local storage. That way we knew it was...

Where is the HTML mangled? I didn't see it in FF3.

I'm not a big fan of dynamic SQL, actually I hate it, but we try to present multiple points of view, and this is not a horrible way to code...

Very interesting. I was expecting to see more complaints about SOX, but maybe I'm not out of touch as a DBA. This law definitely helps DBAS, or anyone that wants...

If you had varchar(max), the procedure might have changed to TEXT when it moved to 2000. You can't use varchar(max) in 2000, and you can't sort, compare, etc. a TEXT...

What you need in a trigger is to write the query to perform the update. Join the "inserted" table with the base table to perform the update.

We would like to...

Is anything different running on the servers? Where is the backup file v the data files on each server? As Jeffrey mentioned, I/O is usually to blame here.

I think you should mention it. That's quite an accomplishment, very few get there, and it's definitely an ice breaker.

It only queries locally, so it works for the local host, not remotes.

However, it will get you lots of stuff if you want it.

Did you create a computed column as GSquared indicated? You can't have an identity that is a character. You have an integer identity and then you have a computed column...

xp_regread?

Query the registry.

I still think he was creating a new word. Like "upgradation"

The question was edited to include an ORDER BY. Questions get edited if mistakes are found.

[drive by post]

Well maybe the questions aren't worse, but the grammar certainly is!

"The problem is that the order by clause was left out on the initail page."

[/drive by post]