Thanks for your comments.

My concern with "properly" locking down a server, be it SQL, IIS or whatever is where do you learn to do it "properly"?

I've read a...

I don't think the question has a single correct answer. I think this one is a case of "an" answer rather than "the" answer.

Having had to do this for...

From a financial perspective Active/Passive is cheaper as the licensing is for the Active instance.

I would say "Comment the code". If you don't comment your code then you are asking to be nailed to your old projects for life or until you resign....

If you mark a table as pinned then it has little or no affect the first time you carry out an operation after it was pinned. It is the...

On this site ages ago there was someone who was running two low grade servers in a profitable dot com and was getting very good performance out of them because...

quote:

---

what did you do?

---

We had a staging database and a live database. In effect...

The main pitfall that springs to mind is making sure that unique id's on each machine do not overlap and that you have a strategy to cope with replication conflicts...

Although I do use replication a great deal we do have a situation where we use DTS to copy data from one server to another.

You can also use log shipping...

We have looked at sending a newsletter type HTML mail and are looking at the sp_makewebtask and sp_runwebtask stored procedures.

In testing we have used these procedures to generate e-mails as...

We use ColdFusion and a ColdFusion based content management system by PaperThin called CommonSpot.

I encourage my developers to avoid direct access to tables and to use stored procedures for just...

Where we are allowed to we compile our VB modules to DLLs and register them on the Webserver.

This allows us to develop and test the code quickly and also reduces...

I see what you are getting at but the situation is that I am installing databases on someone elses i.e. customers servers so this would be a bit "chicken and...

OK, having read around absolutely any user could issue the commands

CREATE TABLE #Tmp(MyField Int);

WHILE (1=1) INSERT #Tmp(MyField) VALUES (1)

Hardly advanced is it an yet this can't be blocked in any...

Thanks Brian,

I'm not so concerned with Access users hitting my box, but I am concerned with breaking something inside SQL itself.

I have to admin that prior to sifting through the...