Ok, thanks for the reply! I figured it would only work within itself but wanted confirmation.

Guys, I regret to inform you it was an id10t error causing the problem. I stopped the firewall service but forgot to reboot. After I rebooted I was...

I have discovered that I cannot telnet to the 1433 port on the db server which seems to indicate that it is not accepting connections for some reason. I...

By the way, I get the error connecting to the cluster through SSMS from physical machines as well as virtual. But I can ping the cluster name from everywhere...

It is a Hyper-V environment with 32 bit Server 2008 installed on the SQL Server and the application server. They are on the same physical host. They can...

I've been looking in Replication Monitor but didn't see the actual replication type (transactional) until now. I have been simply overlooking it as it was in my face the...

Ok, so if I was to walk up to a server i've never seen before and the old admin is no longer avaiable and I wanted to know what type...

No it's not the actual code. I just substituted the names. I actually figured it out and it's working now. Apparently I needed to change the table...

Well the problem is that i'm not getting any return from any records that don't have a value in all of the columns. If a record has a value...

Augh, I can't believe it was that simple. Thank you both!

Any idea on how the query could combine the multiple anniversary dates into a single field so...

Much better! Thanks Ronald!

Thanks Ray! I have it working like a charm now!

Doh!! That's right. Thanks.

Ah, I see! Thank you both very much!

Oh well, I appreciate the lesson regardless. Cheers!