Wayne,

Do you have a question to go along with this?

Thanks for the update. I was wondering how things went for you and the follow up is appreciated.

If you are confident that you will have a COMPLETE set of activity types that are going to occur against the database then by all means you could allow the...

Back with a couple of questions then, is the port open that SQL Server is communicating on open to the internet? Typically by default it is closed.

Are you specifying...

Based on your description of having the app potentially pointing at two servers as you change connection strings the only method of replication would be to enable Merge replication. You...

There is a great post on your problem exactly here - http://weblogs.asp.net/omarzabir/archive/2007/10/19/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx

Please reply and comment as to whether it was useful and fit your situation. There are several links there...

I found the Performance Dashboard reports to be pretty inspiring.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

Enjoy.

Those are the datatypes that would be affected by collation settings. If you select * from sys.types you should see the datatypes represented in the query. You should definitely check...

Once you change it at the database level you will need to update all the text related columns as they are assigned the database collation and will retain that even...

Agreed with all the comments. SQL Server 2005 / 2008 are both very capable of handling that and more, the question really has to be "what do you have skills...

Is the port that SQL Server communicates on open to the internet? If that is the way that you are connecting then that will have to be opened up to...

I haven't looked in a while but I'm pretty sure that Books Online have a pretty good overview and some pretty solid configuration steps. Additionally, it would be good to...

This appears to be a common problem when installing SQL Server on a Read-Only Domain Controller;

From MS

"On a domain controller, the Local Users and Groups tool is not...

Do you have a MAPI profile established on that server with Outlook installed? If not that is the first thing that needs to happen. In that process I alwasy try...

So, there are a couple of ways to do this but first of all, you need to be careful, especially being that you are dealing with production data.

Option 1...