First, maintenance plans and devices aren't related. They're different concepts. You can use devices with or without maintenance plans. Note I don't recommend devices. They're a hold over from older...

http://www.sqlservercentral.com/articles/Administration/2733/

For 2 rows, or 10, or maybe 100, it will scan. It's not worth the effort to scan an index and then go get the data from the table. A...

It can help if there's an index, but not sure that it would help on an index column.

Is there a stop/start in 2005 as there was in 2000? Don't see one, and I think that each time you call the XP, it logs on, doesn't keep a...

I edited your post so it wouldn't require so much scrolling.

http://msdn.microsoft.com/en-us/library/ms188787.aspx

sp_configure changes options. OR you can use SSMS and right click the server, properties, adjust the values there.

I don't think so, but you might need a restart of dbmail. Haven't tested this in 2005 and no Exchange server (or 2) to try with.

Planning and initial development of SQL 11 is going on. I'd file these on Connect (connect.microsoft.com) and get this in front of those people that will do the design. I...

I agree with Glen, this sounds like client tool corruption.

Are things still running, meaning do you see lots of disk IO taking place? I think it could run long, and yes, you're lose the work.

If you have enterprise, you...

Or send him to Alaska :hehe:, let Bob deal with him.

When you click reply, there is a "Last 10 Posts" section below the edit box and reply options. It is closed by default, but you can open it to see...

Very interesting responses, and a lot of what I expected, though Phil's "promote him" caught me a little off guard. Phil, too much civil service work, perhaps?

Firing Evelyn isn't something...

I would run backups. Sooner or later a developer will break something and want to get the schema from yesterday.

Add the AD groups as logins, not the users, and assign permissions to the group.