I'm not going to attack the design too much, but it sounds like you are on quite the slippery slope. If this is a new design, you may want...

Did you configure SSIS manually in the cluster group? The SSIS install is not cluster-aware, so you have to manually install it on the passive node and add it...

I would recommend breaking this post into pieces and ask each question individually. You will get more focused responses.

Here are some quick answers to these.

There are lots of commercially...

Michael Valentine Jones (1/28/2009)

---

Should Michael Earl be...

By the avatars, a few people in here could use the hair cut.

I was working on a whizbang fiber-optic laser beam assembler just the other day. I had to use that phrase in two different documents.

Can a SQL Central "Rain Forest Cam" be set up so we can keep an eye on it?

I suppose we could all be easily fooled by a web cam pointing...

Steve Jones - Editor (1/27/2009)

---

BTW, we've decided to go with a combination of party stuff.

We're donating some rainforest, purchasing 1mm sq ft of rainforest as a celebration. That's a...

That would work. Upsizing from Access eliminates the somewhat unnecessary steps, but if you want to start with an empty database - go for it.

If you have foreign key...

By looking at the xSQL GUI, I would have to say 4 developers and 2 QA people can build it in 6 months. However, I am probably underestimating some...

I'll agree on making sure you have a backup strategy that works for your situation. Read the entire books online section on backup and restore to make sure you...

Toad has one that is free to a certain number of objects. I think xSQL does also.

If you have to do this more than once, I would recommend spending...

To get a base schema, I would suggest you find a tool already available. Migrating from MySQL to MSSQL is so common there are free tools available: http://3d2f.com/programs/9-213-convert-mysql-to-ms-sql-database-download.shtml

If you...

Why are you using dynamic SQL in your T-SQL statement? If you are going to build a SQL statement with a 4 part name, you may as well just...

GSquared (1/26/2009)

---

One of the problems I've seen that causes Excel-as-database solutions is where IT has some byzantine policy for software specification, and it's complex and painful enough that nobody wants...