-- Listing 1: Excerpt from the showViolatingRows Procedure

CREATE PROCEDURE showViolatingRows
  (@constrName varchar(50))
AS
BEGIN
DECLARE @tsql varchar(300)
DECLARE @cnt int
DECLARE @tb sysname
DECLARE @whr varchar(1000)
-- Construct the dynamic DBCC
-- CHECKCONSTRAINTS 
-- statement.
SET @tsql = 
  'DBCC CHECKCONSTRAINTS
  (' + '''' + @constrName + '''' + ')
  WITH ALL_ERRORMSGS '
  SET NOCOUNT ON 
-- Create and populate the
-- ##dbcc table.
CREATE TABLE ##dbcc
  (TableName sysname,
  constrName sysname, 
  whereClause varchar(1000))
  INSERT ##dbcc EXEC (@tsql)