To view all installed sysobjects for the database, run the following query, replacing DBNAME with the name of the relevant database:
select * from sysobjects where xtype ='P' and name like 'aspnet_%'
Sysobject creation scripts are specific to the object. The script below will create aspnet_SchemaVersions:
CREATE PROCEDURE [dbo].aspnet_CheckSchemaVersion
BEGIN IF (EXISTS( SELECT *
WHERE Feature = LOWER( @Feature ) AND
CompatibleSchemaVersion = @CompatibleSchemaVersion ))