• so it only needs to exist in master?

    because at the moment it's in master and in one of other d/bs

    use [master]

    go

    select *

    from sys.objects

    where name = 'sp_spaceused2'