June 7, 2012

sp_refreshsqlmodule (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_refreshsqlmodule(nvarchar @name
, nvarchar @namespace)

MetaData:

 create procedure sys.sp_refreshsqlmodule  
@name nvarchar(776),
@namespace nvarchar(20) = N'OBJECT'
as
declare @ret int
exec @ret = sys.sp_refreshsqlmodule_internal @name, @namespace, 0 -- viewonly
return @ret

No comments:

Post a Comment

Total Pageviews