I think this system is more a way for new people, or widely distributed, but not well known (to each other) people, to find experts.

It doesn't address the load issues,...

Doesn't work for me as well. I'll have to play with it more later, but it seems as though there might be an issue with the case.

If I cast it...

Excellent Job, Roy! I looked back over this for some checking of the book I'm tech editing.

The engine interprets SQL code as if it were SQL 2000 code, so you can't run any 2005 functions. As far as performance improvements in how the tables, indexes, backups,...

Interesting debate, and reading through it, I'm not sure I have things underfoot, but I wanted to chime in.

Currently the business units are separated into 13 databases, so moving this...

It's possible that it's undocumented, in which case, I can't point you to a reference.

I would not recommend you use this.

Tom,

the advice we give is the general advice for anyone. It is not an absolute, and I wouldn't qualify it. The advice is "do not use top without an...

Lowell,

There isn't a better way right now. I periodically spend 10-20 minute killing off threads from my subscriptions.

I'm not clear, are you trying to find a thread or subscribe to...

It sounds like you have some fairly complex requirements. I think this could be done in 1 or multiple databases, but my first thought is that you should engage a...

Part of the issue here is that this could be a security hole. You don't necessarily want to have an XP reading mail.

What you might want to do is have...

http://msdn.microsoft.com/en-us/library/ms131120(SQL.90).aspx

closed

there shouldn't be an issue with backing up the log while writing to it. One is reading, one writing, but SQL and the OS should manage that fine. There could...

Are you looking to script this for use on other servers?

Here's an article on setting things up: http://www.sqlservercentral.com/articles/Profiler/63097/

You probably want to grab the login name of the user, you'll filter...

Interesting debate here, anyone want to turn some testing into an article?