Hey, you can find your own shirts then. I won't need to share if you get picked.

I'd be safe, and both backup master and script logins.

The collation  issue  is probably from some join that causes issues. The same thing can happen with joins in...

Use something like Thom's script. Don't work on a row. Work on a group at a time.

I tend to agree with Grant. Ultimately, if you need to change to a large value, I don't know if the CHAR->larger VARCHAR is worse than a VARCHAR->larger VARCHAR. In...

What Gail said.

These are separate constructs. Transactions ensure that code is all run together or none of it. If you have a single update, there's a transaction...

You could use a CTE

With myCTE
as
(Select ID, TransactionTime, Points From Members Where Points >= 20)
select *
from myCTE
 inner join someothertable a

Mappings can be set/saved by user. Perhaps the service account has a mapping you don't have.

My x5 has all-electric latches. I had one die and the passenger couldn't get out when we parked.

Less than pleasant, and this has to be a safety issue.

There may be some cookies, but I think some of this is handled by your account. My work across multiple machines seems to show marks on one machine are carried...

If you're saying that a computer must duplicate a human in every way, then we're not close. We may never get there, as I'm not sure sentience is possible.

I don't think we have a way to get this back after you've marked all as read. I don't think the software tracks the previous state of posts by user.

I'd say...