Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

String Manipulation Expand / Collapse
Author
Message
Posted Monday, August 25, 2008 11:03 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 5:34 AM
Points: 1,043, Visits: 209
In our database we have more than 2500 StoredProcedures. Name of the SP is having some conventions like versions appending to it.
(e.g) pcarlist_260000
pbuslist_221000
p_vehiclelist_280000. n etc(Without versions too)

Now i want to see all the versions available in my database....
(i.e) How to separate the versions from each name?
Post #558592
Posted Tuesday, August 26, 2008 1:15 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:20 AM
Points: 2,478, Visits: 3,019
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’! **
Post #558642
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse