April 17, 2012

sp_cycle_errorlog (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_cycle_errorlog()

MetaData:

 create procedure sys.sp_cycle_errorlog  -- - 1997/06/24  
as
if (not (is_srvrolemember('sysadmin') = 1)) -- Make sure that it is the SA executing this.
begin
raiserror(15247,-1,-1)
return(1)
end

dbcc errorlog
return (0)

No comments:

Post a Comment

Total Pageviews