Single table also makes searching for content easier... if you went the multiple table approach, every time you added a forum you would have to modify all your queries that searched...

As a followup, looks like Steve and crew are aware of the issue:

http://blogs.sqlservercentral.com/blogs/steve_jones/archive/2007/03/17/1474.aspx

Temp tables are actually created in TempDB. which gets generated from Model every time SQL Server is restarted. Since this is a database level setting, have you checked both TempDB...

The short answer is no. Yes, it has been done but this brings your SQL Server into an unsupported state. SQL Server 2005 is significantly better on information disclosure issues...

In addition to what was said:

1. Tighten down the security on the account being used to the absolute minimum. For instance, make sure it doesn't have any fixed server roles (especially...

It used to be the other way, the way the US uses it. I wonder if the switch-over is due to moving servers from the US to UK?

This is why maintenance windows are so important. There's a real debate as to how long passwords should be kept. We want our users to change their passwords every 30...

This is true... a few apps require sa login rights, which drives me up the wall. DB_Creator rights, too, bug me, having dealt with that and a particular security vulnerability...

To be honest, this article was written when 3.0 FR2 was the top of the line, if I remember right. There have been a lot of changes since then... especially...

It really depends on what you want to do with as to how well it meets certain features. Auditing is a weak point. Multiple environment, multiple database types (a framework...

There are many... too many to list. But if you're looking for someone to come in and shore up your shop, look either to the Solid Quality Learning folks...

From the help:

Certificates are stored locally for the users on the computer. To load a certificate for use by SQL Server, you must be running SQL Server Configuration Manager under...

Actually, you just must be aliased as dbo. Members of the sysadmin fixed server role are aliased as dbo. So is the database owner. For instance, create a SQL Server...

I'm not saying you need to be dbo to call dbo owned objects. My point is that in large apps a reference may get missed here or there... If everything...

If you're using the Principle of Least Privilege, they actually make a lot of sense. Unless object ownership is qualified in every reference, by default SQL Server will attempt to...