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

Implicit conversions are sometimes funny. I'm sure someone knows what rules apply, but I've been caught by this before.

I think it's a design decision that you have to pick one...

Hey!

Mine's better 😉

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

The VM idea is very cool. That's if you have the space for a VM of this size. If you have 100GB of data, not sure you'd do this.

I'd take...

You moving all data or selected sets?

For client side, I assume you mean some database at the client's site and not client machines?

Another alternative is SQL Server Compact Edition, which is just a file and then a .DLL you add to your application. The "server" essentially is just an inprocess thread for...

I'm curious as to how you're doing the count(). Is it based on this bit column?

The reason I ask is that a select count(*) should complete very quickly, even...