Take a look at Erland Sommarskog's home page where he has 2 exhaustive article on error handling.

http://www.sommarskog.se/

This actually appears to be a bug in sp_bindrule !!

If you attempt to add a constraint on the table using

alter table test_table add constraint test_table_COL3 check(col3 <> 0 )...

In the example data, there are 2 rows for vendor_number of 001 and bus_name of "Sally"  with the addresss column having values of "24 west st" and "10 South street".  Which one...

The SQL Server Agent has available certain case-sensitive tokens which are replaced at run time with the actual values.  These are primary used for Alert Response job steps.  There are 15...

When HyperThreading is on, does the extended stored procedure xp_msver return the correct number of CPUs?

execute master.dbo.xp_msver 'ProcessorCount'

I agree with you that using Hungarian notation (or reverse Hungarian notation which I prefer) is a Worst Practice. But the cause of the worst practice is using the...