Object: sp_usage
Description: Provides usage information for stored procedures and
descriptions of other types of objects
Usage: sp_usage @objectname='ObjectName', @desc='Description of object'
[, @parameters='param1,param2...']
[, @example='Example of usage']
[, @workfile='File name of script']
[, @author='Object author']
[, @email='Author email']
[, @version='Version number or info']
[, @revision='Revision number or info']
[, @datecreated='Date created']
[, @datelastchanged='Date last changed']
Returns: (None)
$Workfile: sp_usage.sql $
$Author: Khen$. Email:
khen@khen.com$Revision: 7 $
Example:
sp_usage @objectname='sp_who', @desc='Returns a list of currently
running jobs', @parameters=[@loginname]
Created: 1992-04-03. $Modtime: 4/07/00 8:38p $.
*/
USE master
GO
IF OBJECT_ID('dbo.sp_GGShowVersion') IS NOT NULL
DROP PROC dbo.sp_GGShowVersion
GO
CREATE PROC dbo.sp_GGShowVersion @Mask varchar(30)='%', @ObjType varchar(2)='%'
/*
GGVersion: 2.0.1
Object: sp_GGShowVersion
Description: Shows version, revision and other info for procedures, views, triggers, and functions
Usage: sp_GGShowVersion @Mask, @ObjType -- @Mask is an object name mask (supports wildcards)
indicating which objects to list
@ObjType is an object type mask (supports wildcards)
indicating which object types to list
Supported object types include:
P Procedures
V Views
TR Triggers
FN Functions
Returns: (none)