What about SQL Data Compare?  Do any of you have experience with that?  If so, what is your opinion?

There seems to be quite a bit of support for RedGate.  I tried the trial versions of SQLCompare and SQL Data Compare. I liked them both.  They are easy to use and...

jxflagg,

Does putting SET CONCAT_NULL_YIELDS_NULL ON at the begining of the query set the value for that query only? Or, will it need to be reset to its default value...

That worked perfectly! Thanks 🙂

I got the answer from another forum. It is as follows:

create view ApplicantAddresses

( currstreetnumber

, currstreetname

...

I solved my problem. Here is the method I used:

The following code will enable you to restore a SQL Server 2000 database from a backup device using VB.Net in...

I have tried the following code. However, I get an error stating that an exclusive connection could not be obtained. What more do I have to do? Do I need...

How difficult would it be to cluster two SQL Servers in an active/passive mode without a separate storage device? For example, have a RAID-5 array in each SQL server...

SQLBill,

Wow! I think I would have a meltdown under the circumstances you described.

Your advice is well noted. I believe I will opt for the active/passive cluster with a...

SQLBill,

I agree with your comments.

With respect to option 1, I had planned to log ship to the standby server every 5 minutes and to create a backup to another location...

What do you guys suggest....

I am debating the following two configurations:

1. Two SQL Servers, each with two 36GB mirrored disks. One of these servers will be the primary database server...

This is a great discussion.

I am currently setting up a SQL 2000 database. I am very concerned about availability (up to 15 minutes transition time is acceptable) and redundancy....

Your points are well taken. However, I still wonder about the shared storage device. Isn't there hardware failure risk (i.e. controller cards, etc.)? How do you protect yourself...