Simply put, tables are in fifth normal form when they comply with fourth normal form and the table consists of a key attribute and a non-key attribute ONLY.

Can't you simply add email tasks to each Execute Package flow? Change the Precedence Constraint to Failure. For the package as a whole. Add an email to the Event Handlers....

Nice Article.

Thank you for taking the time to lay this out.

Try sys.dm_sql_referenced_entities or sys.dm_sql_referencing_entities instead. Otherwise it's a nice idea.

Oh wait, I just re-read and saw you were doing this for 2000. Didn't know anyone was still using 2000... ...

Thank you for sharing your work. Well done!

Wonderful Article. I hope you continue this into a "series" and delve deeper into SQL Server vs. MySQL, perhaps in writing code, Stored Object (SPs, Views, Functions, etc) and other...

Thanks for the reply Noel. This cluster is already at SP4.

Hey Bryan,

Did you ever find any resolution to this? We are getting the same on our clustered server running Win 2000 Adv. Server and SQL Server 2000 Cluster with /3GB switch

TIA

Maybe there is a better excerpt.

There was nothing in this excerpt that couldn't have been learned in about 1/2 the time it took to read the excerpt.

Lets face it. At $25 a pop, you can't go wrong. Even if you use it only minimally. It can pay for itself in as little as 1/2 hour of...

A voice of reason, crying out in the dark...! Finally, someone with real-world experience speaks about the CLR...

Thanks for the great article, especially the line:

...And like MDX, there will be...

Actually I was refering to external backup jobs that might be backing up the file system (sorry, I should have made that clearer).

As far as the Perf "errors" in the...

I know that there is a set of backup software technology called OTM (OpenTransactionManager) that can backup files when they are open by taking a "snapshot" of the drive. Is it...

I'll check my files and get back to you on this. Just a suggestion: this would make an interesting article once you are done.

We happen to use SiteScope site-wide. It works OK, but isn't necessarily geared directly towards SQL Server. It's more of a general server/service monitor, although you can write any SQL...