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...

MCA - Technical

MVP - community

the MVP can include technical work, but there are people that just support the Microsoft community in some area, like me, that don't necessarily do...

Not to mention she might trip you or toss you off the track if you get too close!:w00t:

Here, here, be polite.

Ignorance != lack of intelligence.

I voted MVP, because I think it has more recognition, and it's more likely you can attain it. Both require hard work, but...