Ed Wagner (2/21/2013)
Thank you, Perry. I was just getting ready to post that I couldn't do it myself with my permissions.I just love the wide variety of stuff available for learning on these forums. Thanks again.
Change the cursor definition to
Select
name from master.sys.server_principals
where name NOT LIKE 'NT SERVICE\%' and
type = 'G' or Name = 'BUILTIN\ADMINISTRATORS'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉