Thanks for the reply. Yes, IIS won't be clustered, there will be two instances, one on each machine. I'm aware that it is not recommended to run IIS...

But what happens to the cluster if that DC goes down? IIS and SQL Server are on the same cluster, so all data is access via the web app....

Good advice Mohammed...  Thanks!   I need to learn a lot more about the Recovery Models.

Nigel, I'm using a Simple recovery model.  What option would be better and what would I have been able to do?

Steve, used the DTS Import/Export Wizard to create the job and...

Hi Tony et al,

I'm not sure about Q1.  In Q2, my assumption is that one of the other can be the monitor. 

I had the same question you had in...

Hmmm.  Well I understand the ASP issue with access to msdb.  The name is entirely used by the single stored procedure that creates the job so handling of that is...

Well, here's what would happen:

1. A Flag gets set marking that all groups need an update.  I only want the a groups update to happen if a user of that...

Yeah, I got this to work too!  Now, I'm concerned that this is improper use of the Job facility of SQL Server.  I could have a couple hundred of these...

Well, the way it works, is that the stored proc operates on a subset of records that pertain to a group of users.  When a user in...

How can I switch between multi-threaded and single-threaded?  I'm running ASP and ASP.NET 2.0 beta on the same server.

Hi There,

I never really found a solution to my problem.  I ended up re-writing the query and haven't seen the problem again.  Bad queries=bad performance!

I've recently re-written a particular query...

No workgroup edition?  It became available in April.  Take a look at the table on this page:

http://www.microsoft.com/sql/evaluation/overview/default.asp

The OEM version of SQL Server 2000 apparently comes pre-installed on servers bought...

Have you ever gone that route and pursued with the FBI?  Do you contact the local office by voice or e-mail?  How does it work exactly?

Ok All,  GOT IT!

I found an SQL Injection vulnerability.  I found a script file that was placed on my server which caused my server to connect via FTP to a...

I've found that if I transfer the passed in parameters to local variables declared in the stored procedure where this query is called, the query does find the indexes on...