You can answer your question yourself. Click on the Include Actual Execution Plan button and run your query. Inspect the plan to see which of the indexes were...

Is this homework? What have you tried so far?

John

Make sure you qualify the table name with the schema name. You'll find that in the results from INFORMATION_SCHEMA_TABLES.

John

Yes, and the name of the beer wasn't the only pun. There was something in the description about COUNTing the DISTICT flavours, and so on.

Don't get me started on...

I can recommend Select Star ale from Redgate, as served at SQL in the City on Friday. I think it's made in a brewery in Essex that I hadn't...

My advice is to save yourself a world of pain, and restrict names of databases, objects, columns etc to alphanumeric characters and underscores.

John

It's a miracle! I meant to choose 12, but I ticked both 10 and 12 by accident, and ended up with a point. What are the chances of...

I don't know whether anything like this applies in your case, but I've had trouble with synonyms before. It happened when I restored a second copy of the database...

Well, you say that you can't connect to the database where it is to run a DBCC check. Therefore you don't know what't wrong with the database. If...

OS error 21 means "the device is not ready", so, as the error message suggests, you probably have something wrong with your disk. I'm not sure whether the error...

That's clear. What specifically do you need help with?

John

As Suresh suggested, check the default database for the service account. If it's anything other than master, change it to master.

John

Have you looked at the SQLAgent.OUT file? Is there anything in the event log?

John

Charlie

That's right. Either that or fail over the whole group to another node.

John

Can you start the service from Cluster Administrator? From Services? If you can start it from the latter but not the former, that suggests that the problem is...