Did you trace the deadlock graph (T1222)? That should help you solving the problem.

You have two options. One is writing your own function which generates new ID's.

The second option which I would prefer is using two columns one for location and one for...

Rudy Panigas (12/16/2008)

---

I've tried the SQL Web Administrator tool. It's only good for SQL 2000 and does not work with SQL 2005 and SQL 2008.

So I'm still looking for a...

RBarry, I think you missed the part that SQLMail doesn't work with the 64-bit version.

Rudy Panigas (12/16/2008)

---

Yes I understand the possible issues with this configuration. If you have assigned the right roles/rights to the right users this should not be an issue.

My reason...

In 2005 it's called Data engine tuning advisor and you can fingd it in SSMS under Tools.

kendal.vandyke (12/16/2008)

---

I believe you're talking about sp_processmail, but in general it's not really recommended that you do this because you could blindly execute malicious code that does nasty things to...

You can't receive mails using database mail, but you can use SQL mail which is basically the same as in SQL 7 or 2000. Then just schedule a job to...

I think that you installation of RS was ok only it wasn't configured. During installation you can choose if you want to configure RS with the default settings or you...

I just tried it and it works fine for me.

No difference if I run it on the server or from a remote client.

The column has_drop_pending in cdc.change_tables is...

Steve Jones - Editor (12/15/2008)

---

My guess is that SET FORCEPLAN on is a setting, but likely people writing Books Online are having trouble coordinating things with the product so large.

I'll...

I'm pretty sure that it's depending on the SP which is installed for the client tools.

On all my machines you only get the "Start Job at Step" option, but...

Personally I would say all four answers are correct because you have the FORCEPLAN option which essentially is a query optimizer hint.

Even BOL talks about a query optimizer hint.

http://msdn.microsoft.com/en-us/library/ms188344.aspx

Paul,

the part of the errorlog you've posted is from before the failover. I would be more interested in the errorlog after the failover if it contains any messages why...

In a cluster the whole instance does a failover and all databases inside the instance should be available after the failover.

Did you get any errors in the SQL Errorlog...