USE master

GO

IF OBJECTPROPERTY(OBJECT_ID('dbo.sp_script_PK'), 'IsProcedure') = 1

   DROP PROCEDURE sp_script_PK

GO

CREATE PROCEDURE sp_script_PK

       @tabname  sysname = ' '

      ,@dropflag tinyint = 0

AS

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS OFF

DECLARE @buffer varchar(255)

IF @tabname = ' '...

EXEC sp_MSForeachdb 'if "?" IN ("db1", "db2", "db2") EXEC sp_dboption ?, "dbo only", true'

Edited by - jdausubel on 12/22/2003 10:51:35 AM