Thanks, and you are welcome. Be sure you understand how it works before you implement it though. You need to be able to maintain it. I'm also...

Are they connecting to the server using Windows Authentication or SQL Authentication? If SQL then you won't get NT User Names.

Running Repair without knowing what the problem was was probably a mistake. See Paul Randal's blog post here.

Normally with corruptions you will want to restore from good...

This will work although you might want to do it in more then one pass:

SELECT

fullname,

STUFF(

...

Roy Ernest (10/12/2009)

---

Steve Jones - Editor (10/9/2009)

---

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at http://ask.sqlservercentral.com. Not my idea, and I'm not...

Can you post at least pseudo code for the trigger?

Sergiy, is close, but because you said it is an insert trigger you can't use the deleted table. You can...

Thanks for the support guys. I'm just uncomfortable with self-promotion. Of course, until I have 1000's of readers I guess I have to.

You might be interested in these articles:

Sending Multiple Rows to the Database From an Application Part I[/url]

Sending Multiple Rows to...

Duh, I didn't run a test for when the id doesn't exist in the table already, and in that case (I substituted 0 for 10) the try catch is...

I'm sure someone else will have more wisdom to share than I, but since it is a unique index it would be an index seek to check for the dupe...

Don't know how you'd do it in 2000. In 2005 sys.triggers has an is_disabled column. I don't see anything in sysobjects that tells you.

One issue you will run into is that the sysjobhistory table is purged regularly and only keeps a certain # of total rows and certain # of rows per job.

Do...

Yup. I love profiler (on a dev instance of course). I actually think I have...

Melton (10/9/2009)

---

Jack Corbett (10/9/2009)

---

There is also a new concept out there is SQL Blog land started by Jorge Segarra aka SQLChicken called SQL University where some pretty well-known SQL bloggers...

Here's the query that SSMS uses to retrieve that information:

SELECT

log.name AS [Name],

ISNULL(log.default_language_name, N'') AS [Language],

l.alias AS [LanguageAlias],

...