Gail:

This issue just came to my attention when trying to attach a database on a SQL Server 2008 R2 server.

Usually I am restoring databases from a backup instead of attaching...

Thank you so much. That was exactly the problem. Such simple things can waste so much time!

You would think that searching BOL, using keywords from the error message,...

Is this something that you need to do once or regularly? I don't know who designed the table and specifically the description column, but it is truly a bad...

I see this is an old post but I would like to know the answer to this question ... did you find out how to exclude the document map from...

I have not received an error -- before removing the SQL Server installation to reinstall I am making sure that I have a means to restore all of the exisiting...

Did you have any issues with SP4? It seems to have corrupted the security on my test system. I am trying to find out if there is something...

People might be trying to find some more info about SP4.

I know I have been looking to find comments from anyone who has actually applied SP4 in a production environment.

I...

With all that you have already looked at it seems to point to a data issue.

I suggest that since you only have one record in 7800 that cannot be updated...

Since I don't know .... what does 'RTM' stand for?

I haven't seen much about SP4 being available for general use. Is there a reason it isn't being widely...

Yes, I verified the the user group exists on the local server domain -- and I am actually selecting it from the list of user groups to make sure that...

could you point me to a succinct article that explains the difference [and how they are defined and used] between a column that is "included" in an index and a...

Gail -- thank you. That's what I needed to know. I've never been certain if the optimizer added it twice. Or if the order changes.

Thank everyone else...

Let me ask you what you are trying to accomplish. There may be a better/easier way to go about it.

That is a lot of "distinct" records returned.

Good thoughts. I did think of those, so I have tested it using my own email address [from the same domain] and I have tried comma and semi-colon. ...

Database mail works fine from SSMS and from SQL Agent jobs both on the same server.

Our SMTP logs are huge but will look there also. I was...