Congratulations, and thanks for the information.

I'd like to whack the Quote button. It gets a little crazy at times.

I edit mine down to just the person I'm quoting.

If that doesn't work, double check server and client tool versions. Sometimes those cause issues of they are different.

I have a few people a year sending me email for refunds for SSWUG. Apparently they get upset when SSWUG links to me.

TheSQLGuru (6/1/2009)

---

Believe it or not Steve I have had not one but TWO hiring managers tell me in the last few months that my rate was significantly LESS than what...

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.