Multiple instance clusters are supported. See Brian Knight's articles on clustering (most of it is applicable to Win2k3).

Also, you might check out the high availability guides from MS:

Better still would be to write a function that takes a string and returns back a string. Replace any code that you're concerned about. For instance, single quote becomes two...

MDAC = Microsoft Data Access Components

Location on Microsoft's site: MSDN Data Access and Storage home

Under Downloads | Product and Update Downloads you'll find the various MDAC...

The sp_OA stored procedures also default to sysadmin role members only. These stored procedures can allow access to any objects (programming terminology) that are registered on that particular server. It's...

Yes. SQL Server 2000 must be installed first. It also must be brought up to SP3. Then you can install SQL Server 2005 Beta 2 in a side-by-side installation.

Bad news for you. Any login to SQL Server has access to the master database. The guest user is required to be activated on master. Therefore, if you have a...

Before creating the stored procedure, manually create the linked server. Then create the stored procedure (without the GOs). Once the stored procedure is successfully created, manually drop the linked server....

You don't have to, no, if it's just a thick client. You'll try and want to keep MDAC versions in synch. I believe MDAC 2.7 SP1 Rerfresh is what is...

Views. While SQL Server actually works at the column level, I've found that while most folks will check to see if a person has access to an object like a...

Agreed. You may want to do some performance monitoring of the SQL Server to see if it is freezing like that. If it's not a processor/memory limitation, it may be...

If you use outlook, you can set up MAPI. Outlook can be setup to use an SMTP/POP3 server. However, if Outlook is out as well, look at the following thread...

There is no guarantee in the subject, no. You can try and specify the <b> </b> tags but this isn't guaranteed to work for all email clients. The RFC for...

You can do so using SQL Profiler or the sp_trace functions. You'll need to use the Audit Logon and Audit Logout event classes. I should have a forthcoming article on...

If you have a named instance and you need to connect through a firewall, you can statically set the port for the instance. Then, when connecting from the other server,...

The cluster will require an IP address. Each physical node will require an IP address. Each virtual node will require an IP address. All of these need to be distinct.

Now,...