You can rehit the menu on the left side.

We're working on it.

We actually have lots of newbie type articles. The high end stuff typically ends up in SQL Mag or someplace else.

That being said, what types of things are you looking...

On the list 🙂

John, can you post a screenshot and I'll add this to the list.

FYI, if you have Office 2007, I get misspelled words in forms underlined in Red. Kind of cool.

At...

Thanks for the update and good to know. We are looking at some search enhancements over time.

No Halo dance, but we got the Crazy Hair dance 🙂

http://www.dkranch.net/videos/2007/crazyhair_a.MOV

Agree with Chirag, you must have some connection string mis-configuration.

Bad URL on our side. We had a redirect that sent you to Amazon, but apparently some filters don't like that. We should have a fix for Mon.

It can address this memory.

http://support.microsoft.com/kb/274750

As much as you can spare. I'd go 14-16GB.

Basic question, did you start mail?

In SQL you need an xp_startmail to get things going and open the profile before you can xp_sendmail.

Something else must have happened. Remove BUILTIN/Adminstrators from the sysadmin role should have only removed that role.

When you say it deleted all logins, how do you connect now? What do...

Mark, I think you've described this well.

I tend to add a "return" to all my procs, which returns 0 by default. It's just an easy way for me to see...

How much activity is there on the server? CPU and memory being used? Gail has some good counters to check above.

Also, are the data and log on different physical arrays?...

At 20GB, you'll need to know PAE as well.

http://msdn2.microsoft.com/en-us/library/ms190673.aspx

Be sure you add lock pages in memory as a right.

This was a change in the forum upgrade. Not sure why InstantForums changed the default, but they did. You can set this in your Forum Control Panel, Forum Settings.

http://www.sqlservercentral.com/Forums/EditForumSettings.aspx