May 16, 2012

sp_MShelp_profilecache (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_MShelp_profilecache(nvarchar @profile_name)

MetaData:

   
CREATE PROCEDURE sys.sp_MShelp_profilecache (
@profile_name sysname = NULL
)
as
declare @profile_id int
declare @retcode int

--
-- security check
--
exec @retcode = sys.sp_MSreplcheck_subscribe
if @@ERROR <> 0 or @retcode <> 0
begin
return(1)
end

select @profile_id = NULL

select parameter_name, value
from dbo.MSmerge_agent_parameters
where profile_name = @profile_name

No comments:

Post a Comment

Total Pageviews