Binaryworld - Run Script for each user ... [ SQL Server -> Stored Procedure ]

/*
This stored procedure can be used to run some work for each user
tables in the particular database.
You can pass the database name and the string to execute into
ForEachUserTable stored procedure, as in the example below (if the
database name was not specified, the current database will be used):

EXEC ForEachUserTable @dbname = 'pubs',
@str = "DBCC CHECKTABLE ('?')"
*/

IF OBJECT_ID('ForEachUserTable') IS NOT NULL DROP PROC ForEachUserTable
GO

CREATE PROCEDURE ForEachUserTable (
@dbname sysname = null,
@str sysname
)
AS
DECLARE @execstr nvarchar(255)
SET NOCOUNT ON
IF @dbname IS NULL SELECT @dbname = DB_NAME()
SELECT @execstr = 'EXEC ' + @dbname + '..sp_MSforeachtable @command1="' + @str + '"'
EXEC(@execstr)
GO