GilaMonster (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the OUTER JOINs...

Brandie Tarvin (8/4/2010)

---

CirquedeSQLeil (8/3/2010)

---

I have to disagree with this statement. As an amateur historian, I don't see the...

Duran (8/3/2010)

---

Hello,

OK, so the instances would failover and continue to be available on the one remaining node, so the hardware on each node would need to be powerful enough to...

I couldn't have done that better 😎

Very, very nice plan and bug analysis.

Who am I ? Sometimes this is me[/url] :alien: and most of the time this is...

That depends on your resource group settings.

By default - for sqlserver - it will be configured to become active at the onther node(s).

Keep in mind, this will be done at...

Jamie Wormald (8/3/2010)

---

If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any...

Your disk definitions need to be in the same cluster group as the one you want to install your sqlserver instance on.

Create a cluster resource group that only holds the...

Clustering a sqlserver instance (can host multiple user databases) is no problem.

Load balancing does not exist for sqlserver.

Off course you can load balance the applications, but when they get...

maybe this can get you started ...

select [Server]

, JobNaam

, JobEnabled

--, last_run_date

...

Good point.

Those are the apps that should be documented in a failover checklist.

At least they should be mentioned in the migration/upgrade plan for the db.

I doubt order is of any concern with the current versions (2005/2008).

You need to keep in mind the total length of fixed data types is still restricted to 8060...

- I would start with the SQLServer upgrade advisor (SQLUA).

This will point to potential issues with your database(s).

- I would also run the Best practice tool, to see how...

One small addition to Gails reply:

If you have db-access...

You could have fetched the schema using:

select object_schema_name(parent_object_id) as TheParentSchema

, object_name(parent_object_id) as TheParentObject

, object_schema_name(referenced_object_id) as TheRefSchema

...

does your service account have the authorities to read the attached file(s) ?

edit: yes, or it should have provided the error:

Msg 22051, Level 16, State 1, Line 0

Attachment file <filename>...