A small change.. cursor for obtain all schemas and set it to a variable used in method:

SET NOCOUNT ON

DECLARE @CopyFromSchema Varchar(50)

DECLARE @CopyToSchema Varchar(200)

DECLARE @ObjectName Varchar(100)

---- Set The Paramenter

---- Now you can pass multiple parameters in @ObjectName

SET @CopyFromSchema = 'dbo'

SET @CopyToSchema=''

---------------

DECLARE @schema NVARCHAR(50),@schema_id int

DECLARE x CURSOR for

SELECT name,schema_id FROM sys.schemas --WHERE name NOT LIKE 'db%' AND name NOT LIKE 'sys' AND name NOT LIKE 'inf%' AND name NOT LIKE 'D%' AND name NOT LIKE 'ad%'

OPEN x

FETCH NEXT FROM x INTO @schema,@schema_id

WHILE @@FETCH_STATUS =0

BEGIN

IF LEN (@CopyToSchema) =0

SET @CopyToSchema=@schema

ELSE

SET @CopyToSchema=@CopyToSchema + ',' + @schema

PRINT @CopyToSchema

FETCH NEXT FROM x INTO @schema,@schema_id

END

CLOSE x

DEALLOCATE x

Att.

Disney :w00t: