insert script_user_xps into table scripts


DELETE scripts WHERE name = 'script_user_xps'
GO
INSERT scripts 
VALUES('script_user_xps','/* build create scripts for existing user definded remote')
INSERT scripts 
VALUES('script_user_xps','   stored procedures. Grant execute permission to all users')
INSERT scripts 
VALUES('script_user_xps','   with sysprotects entries for the xp */')
INSERT scripts 
VALUES('script_user_xps',' DECLARE @procedure varchar(255), ')
INSERT scripts 
VALUES('script_user_xps','         @objectName varchar(30), ')
INSERT scripts 
VALUES('script_user_xps','         @file varchar(255),')
INSERT scripts 
VALUES('script_user_xps','         @user varchar(30)')
INSERT scripts 
VALUES('script_user_xps',' SET NOCOUNT ON')
INSERT scripts 
VALUES('script_user_xps','  DECLARE object_cursor CURSOR')
INSERT scripts 
VALUES('script_user_xps','  FOR')
INSERT scripts 
VALUES('script_user_xps','  SELECT DISTINCT o.name, c.text, u.name ')
INSERT scripts 
VALUES('script_user_xps','  FROM master..sysobjects o, master..syscomments c,')
INSERT scripts 
VALUES('script_user_xps','       master..sysprotects p, master..sysusers u')
INSERT scripts 
VALUES('script_user_xps','  WHERE c.id = o.id')
INSERT scripts 
VALUES('script_user_xps','  AND p.id = o.id')
INSERT scripts 
VALUES('script_user_xps','  AND p.uid = u.uid')
INSERT scripts 
VALUES('script_user_xps','  AND o.type = "X"')
INSERT scripts 
VALUES('script_user_xps','  AND o.category = 0')
INSERT scripts 
VALUES('script_user_xps',' OPEN object_cursor')
INSERT scripts 
VALUES('script_user_xps','   FETCH NEXT FROM object_cursor INTO @objectName, @file, @user')
INSERT scripts 
VALUES('script_user_xps','     WHILE (@@fetch_status <> -1)')
INSERT scripts 
VALUES('script_user_xps','       BEGIN')
INSERT scripts 
VALUES('script_user_xps','         SELECT @procedure = "EXECUTE sp_addextendedproc " + CHAR(39) +')
INSERT scripts 
VALUES('script_user_xps','                             @objectName + CHAR(39) + ", " + CHAR(39) +')
INSERT scripts 
VALUES('script_user_xps','                             @file + CHAR(39)')
INSERT scripts 
VALUES('script_user_xps','         PRINT @procedure')
INSERT scripts 
VALUES('script_user_xps','         PRINT "GO"')
INSERT scripts 
VALUES('script_user_xps','         SELECT @procedure = "GRANT EXECUTE  ON master.." +')
INSERT scripts 
VALUES('script_user_xps','                             @objectName + " TO " + @user')           
INSERT scripts 
VALUES('script_user_xps','         PRINT @procedure')
INSERT scripts 
VALUES('script_user_xps','         PRINT "GO"')
INSERT scripts 
VALUES('script_user_xps','         PRINT ""')
INSERT scripts 
VALUES('script_user_xps','     	 FETCH NEXT FROM object_cursor INTO @objectname, @file, @user')
INSERT scripts 
VALUES('script_user_xps','      END')
INSERT scripts 
VALUES('script_user_xps',' DEALLOCATE object_cursor')