DUPLICATE POST

please post all responses over here

@Ron,

Excellent! I see I need to look into WITH TIES a bit now.

First, I'm going to agree with some of the things already mentioned. You do not have a direct upgrade path for what you're wanting to do, and I'd also agree...

I have a HP DV-7.

Whatever laptop you get, ensure that you check the OS requirements for installing SQL. I had to upgrade from Vista Home to Ultimate to be able...

Someone's being a smart-a**

I don't know that I agree with being insecure, but I know that in spite of the vast amount that I have learned about SQL, I know that there is...

Steve Jones - Editor (7/15/2010)

---

I'd would be very curious if this worked when you failed back.

So, just to make it clear.

NodeA - Normally active node

NodeB - Normally passive node

- Jobs...

When I run this:

declare @TestTable table (CounterDateTime char(24))

insert into @TestTable

SELECT '2010-07-06 21:00:01.572' UNION ALL

SELECT '2010-07-06 21:00:31.463' UNION ALL

SELECT '2010-07-06 21:01:01.479' UNION ALL

SELECT '2010-07-06 21:01:31.479'

select CounterDateTime, IsDate(CounterDateTime) from @TestTable

I get all...

I find this of dubious value. However, since you can also select from views and some functions, it might be of some use to do this. Personally, I assume that...

Well, the scheduled jobs still aren't running from the active node (which is normally the passive node - active after a failover). I'm pretty sure that if I fail it...

This particular cluster is a "test" cluster - the first point in our migration path where a cluster is utilized. I need to fail it back to it's normal mode...

Well, I'm usually loath to go around restarting things, but stopping and restarting the SQL Server Agent from cluster administrator fixed this. I'd really like to understand a bit more...

Well, cluster administrator is saying that the sql agent is running on the active node... but let me try restarting it to see how that affects things.

I also just found...

Yes, The cluster did failover.

If you connect to the Virtual clustered node, do you see the jobs/agent/service accounts the same as you might see them...

I have to admit that I got this correct, but for the wrong reason. In looking at the question

Using the default Northwind database on a default install of SQL...