• To select all SP's with a specific versionnumber:

    select * from sys.objects where type = 'P' AND name LIKE '%_268000'

    To see all used versions (including how many SP's are available in that version):

    select

    count (object_ID) as NumberOfSP

    , right(name, 7) as VersionNumber

    from sys.objects

    where type = 'P'

    group by right(name, 7)

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **