The Redgate tool SQLTest for SQL unit testing now offers the ability to add tests from SQLCop however the Redgate tool only comes with few of those tests prebuild.
Since tests are just stored procedures I am sure somebody has implemented more of those tests.
Are you willing to share? Anyone?
I wrote SQLCop. I've been working with the fine folks over at Redgate. Originally I provided 5 (or so) tests as a proof of concept. Since then, I have also provided the remaining tests that are included with SQLCop. You should expect the remaining tests to be included in their next release of SQL Test.