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...

You haven't stated your exact requirements, so I can't really provide any recommendations, except to consider using SSIS instead of this.

The answers to your original two questions are:

(1) Yes, you...

Bodhan

You've posted in an SSIS forum, but it sounds as if you're trying to do everything in T-SQL. If you are indeed using SSIS, it's better to take advantage...

The error message is fairly explicit. You've got a value in your nvarchar column that can't be converted to int because it has a "D" in it. The...

What is the compatibility level of your database?

John