Thanks for the Reply Nils.

I had already ruled out triggers and this is definately a table this was occurring on.

I know it is very strange.

I was able to repeat...

Thanks for your reply.

This was first encountered by a developer before it was reported to me(DBA).

I confirmed the problem by repeating it on my own work station and management studio...

You're welcome. I can't tell you how many times I have wasted hours of stressful troubleshooting and the problem/solution was right there in front of me the whole time.

Regards,

Mark Ganci

Hello. What was the original trouble or reason for trying to start in single users mode?

Also based on this message in your log:

2011-05-25 18:17:24.53 server initconfig: Error 3(The system cannot...

I have resolved this issue.

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/16/unable-to-create-maintenance-plans-after-service-pack-2-is-applied-on-sql-server-2005-fail-over-cluster-instance-running-on-windows-2008-cluster.aspx

One of my nodes was registered lowercase ex sever11 versus SERVER11.

Coincindentally all attempts to apply SP3 to "ACTIVE" node was on this...

Thanks Harold. That's exactly what I was thinking. If Sql version, Virtual server name, ip address,instance name, install path, and drive letter are the same then I should be...

I am using this article as a guidline but it just doesn't make sense to me. I might be missing something.

If I move the entire SAN drive (which contains all...

Harold,

That is correct. Only the OS level is changing from server 2003 to server 2008.

SQL server version will remain 2005 svc pk 3.

According to the article id...

If I need to restore the databases, why bother bringing the old san disk over (the disk with the original system and user databases)? I can just leave the new...

Good Idea. Keep tract of realtime dates/times from Sysprocesses.

Less obtrusive and less complicated then other options.

Probably safer too.

Thank you for the idea.

Thanks

Mark G.

My problem is I need to find successful logins and more specifically last login date time.

Last login date time is available in sys.dm_exec_sessions but is not recorded unless

Common Criteria is...

It looks like SP2 32 bit is out for this but I cannot find sp3 x64.

Did you ever find what you were looking for and how did it work out...

It looks like SP2 32 bit is out for this but I cannot find sp3 x64.

Did you ever find what you were looking for and how did it work out...

Yes we did get cluster/server to see storage... intially our thoughts were since all 3 servers were running with out cluster services running none of the servers were the disk...

I resolved my issue.

I exported the reg key from a working node and applied it to the new nodes.

(the keys between working nodes were virtually identical so I knew...