Did not know that, though I've avoided cascading deletes and updates for years.

Does anyone use this?

That's a fair response, Paul, and what I'd expect. I think the big issue is that the built in tool is good enough, even if it's not that great. ...

You'd have to move the child, disable the FK, or drop the FK. My guess is they are moving the child to another record, or a holder record.

Or they don't...

Why not? Just curious. If it really helps you, is it...

I don't think they're substituting diseases. As I read it, they don't differentiate down when the sample size is small, so you don't get Diabetes I or II for small...

You should go buy a book on the topic. There are plenty of them to help guide you along.

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=SQL+Server+&x=0&y=0

I don't believe so. The indexes would need, potentially, to have the updated information in them. I'd hope that an increase in the varchar size, without new data, wouldn't touch...

The difference between a VM and physical server is the resources allocated to it. So you can functionally do anything in a VM (perhaps not some USB stuff), but it...

I tend to agree with you on SQL Intellisense. I don't want it to figure out objects for me, especially with functions mixed in. For those of us that like...

Might have someone else at work head over here and compare experiences. It would be good to have multiple experiences to share back with your team.

Dive

You can parse out things possibly that can't run. There aren't a lot of commands. I would question the need for this particular command.

Snapshots are still an issue of disconnection for users, and in my mind, that's still an issue.

Replication is an issue if it breaks. It should pick up itself, or you...

I think your solution is likely a good one given your constraints. In people that I've known with this issue, the SAN is always started first, before anyone punches on...

Using SQL 2000 there isn't a good way, other than a trace, to track this down. You won't see previous changes, but you can track future ones with a trace.

Very...