you can check when it was created and when it's definition (or one of its dependent objects) was last modified but that is about it.

Sure. I don't have it here right now, so I'll have to send it from work tomorrow.

Yeah. It's easy to get it to work when you want to pipe it into a Varchar(MAX) variable and execute it, which is what I usually do, because the...

They are both ANSI joins. The commas are the Old (SQL 89) syntax, the "JOIN"'s are the New (SQL 92 and later) syntax. OK, New-er syntax.

I much prefer...

GSquared (6/18/2008)

---

If I'm reading it correctly, it looks like the whole thing could be turned into a couple of insert statements and update statements that would run MUCH faster than...

I think that you're missing something from your new Install or it lost the location of something.

Aren't the first two affected by configuration settings on the server or instance?

Check out the IS_MEMBER() function in books on line. If you know what explicit groups you want to check for, this will do it.

If you need an actual list...

Jeff Moden (6/18/2008)

---

rbarryyoung (6/18/2008)

---

Well, sort...

Matt, Jeff:

FYI, I've already used this trick today to put up a "quick & dirty" Service Broker monitor. sweet...

Thanks again,

Glad I could help.

Oh, and that's another thing that I discovered today: They do not ALL contain CR/LF's. Some of them contain just LF's! That's a nice little inconsistency.

Well, sort of. There's...

OK, fair enough, I can see that is was not caught up to the changes that you were making.

To answer your question then: from a performance standpoint, 2 different version...

Carl Federl (6/17/2008)

---

SYSCOMMENTS is no longer a table but is a view included for backward compatability. Module source is now in a varchar(max) column and can be obtained using...