What is a common mistake with Stored Procedures in SQL Server?

Putting all business logic into stored procedures can create tight coupling and make application behavior difficult to test and evolve.