Wow, I never knew this existed. This is very helpful.

Thanks for the replies. In my current system we use this for database consistency checks that we are unable to use hard constraints on. So these emails are...

Sorry, I did forget to include the splitstring function:

CREATE function [dbo].[SplitString]

(

@STR nvarchar(4000),

...

In addition to those already listed by others, I added checks for:

- Disabled Indexes (no way to tell in the GUI that I am aware of)

- Auto Create/Update statistics set...

Your responses make sense, thank you both.

Thank you for the replies.

The refdate field is equal to the crdate field in most, if not all, of the records.

Most of the records are #[eight digit hex], but there...

I've only been in the professional workspace for 5 years now, so I probably don't have the perspective that most of you do. I like the idea of a...