I think that it's because a group used as a login, as in this case, doesn't need the user to be added.

FYI, with 2005, you ought to be using ALTER...

Now THAT put a smile on my face this morning. Apparently I'm not the only one that has bad days. I'll have to bring that up next week to Phil.

Well outside of conferences I go throw < a case of beer a year and 3-4 bottles of wine, but I will have a few tonight. Came home to a...

Don't turn on auto-shrink, it's a bad idea.

If this is a server, then you probably want regular log backups to control the size of the log, and give you recovery...

Keep in mind that the order of rows returned is never guarenteed without an ORDER by clause. You should include that if you are looking for the first anything.

Chris,

You are welcome, and best of luck with that. I haven't met many people that didn't learn a lot from additional education. Even if it didn't directly help in their...

You'd want to run a trace/Profiler for permission changes while using the tool. The tool must be doing something. SQL Server never loses permissions or changes them itself. Some user...

Can you run this in VBSCript from a command prompt and have it work? Or maybe using a scheduled task and the account that IIS is using? I would almost...

You'd have to provide more information about the code here if you want help.

There are performance problems with functions at times, so you want to minimize them in large data...

My guess that some of the items Enterprise Manager users are locked to your account. I assume this application is published, correct?

Do any of the EM items work?

Moved to 2005 forums.

The only way I've seen to synchronize these is manually. You need to script them out and move them as they change.

I think that query is a little broken at times. Not sure why, and it's a low priority. Sorry.

Please check the forum before posting. Moving to t-SQL

Sorry, slip of the finger. They are supposed to be hidden until that date, but I checked the wrong box. I'll clean it up.

Well, I'm one of the people running the public speaking merit badge for the local Boy Scouts, so hopefully I've learned a few things I can pass on.

I think part...