Oops forgot to renumber above.... Good thing I don't work for BBIS (Big Brother Internet Security) - I could have brought down the banking industry...

1. Our government could not handle Internet Security effectively. We would probably see far worse security breaches (at least initially and for sometime thereafter).

2. Keeping everyone up...

I experienced 1,1 also. The ms link provided concerning rowcount had this to say:"Statements that make a simple assignment always set the @@ROWCOUNT value to 1. No rows are...

I suppose I should have qualified my statement with "an environment running multiple mailservers, content filters, and sql server instances."

The solution presented will not work for me, we do not...

No offense, but xp_sendmail is a horrible solution! xp_sendmail uses cdo, which is buggy and prone to crashing without giving any error messages.:crazy:

Go to http://msdn.microsoft.com/en-us/library/ms189505.aspx, and Microsoft...

Good article.

I use VIEW_ to prefix all views.

I completely agree on naming fields EXACTLY the same from one table to another (if they refer to the same data). I...