I can't argue about how annoying they are, but they do (when they work) give a nice, transparent view on what's being done and on what schedules. With the solution...

Actually, it seems like using IDENT_CURRENT is a terrible idea in the context of my question. As you've pointed out, it returns the last IDENTITY value produced for a...

Not much of a response here, but the bottom line is that this is a known issue with Microsoft's IFilter for Word. I'm going to try and work around...

Ok, I now know what's causing this problem, but I have no idea how to fix it, or if a fix is even possible.

I discovered that for every document in...

Adi Cohn-120898 (3/24/2014)

---

The parentheses have to be used when you have a none standard name. For example if you have space in the constraint's name. In other cases...

Great answers, thank you. Sounds like I definitely want to explicitly name the constraints.

Do the parentheses around the default value itself not mean anything, then? In the first...

Thanks Grant. We actually started from a plan of having an appointment status, but it quickly gets complicated, especially as many statuses aren't mutually exclusive. I've gone with...

Thanks very much for the feedback, both of you. I guess what puts me off putting the cancellation information in the Appointment table is probably a neurosis that dislikes...

Thanks for that. I did think about using an iSCSI connection, that might well be a way around the problem.

Thanks for the reply. I know those features are supported in every edition, but the implication on this page is that FILESTREAM and File Table only support files on...