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')