哪些扩展存储过程存储在sql server中 [英] Where are Extended Stored Procedures stored in sql server

问题描述

任何人都可以告诉我在哪里可以找到扩展存储过程。

我想找到xp_readerrorlog文件。存储过程sp_readerrorlog只接受4个参数，我想再添加3个参数实际上是由sp_readerrorlog允许的。但我想确保扩展存储过程xp_readerrorlog也接受7个参数。

Can any one tell me where can i find extended stored procedure.
I want to find xp_readerrorlog file.The stored procedure sp_readerrorlog is accepting only 4 parameters and i want to add 3 more parameters which are actually allowed by sp_readerrorlog. but i want to make sure that the extended stored procedure xp_readerrorlog also accepts 7 parameters.

推荐答案

两个存储过程都是系统的一部分，你不能更改它们。 。

sp_readerrorlog调用xp_readerrorlog

Both stored procedures are part of the system and you can not change them...
sp_readerrorlog call xp_readerrorlog

create proc sys.sp_readerrorlog(
	@p1		int = 0,
	@p2		int = NULL,
	@p3		nvarchar(4000) = NULL,
	@p4		nvarchar(4000) = NULL)
as
begin

	if (not is_srvrolemember(N'securityadmin') = 1)
	begin
	   raiserror(15003,-1,-1, N'securityadmin')
	   return (1)
	end
	
	if (@p2 is NULL)
		exec sys.xp_readerrorlog @p1
	else
		exec sys.xp_readerrorlog @p1,@p2,@p3,@p4
end

xp_readerrorlog不是真正的存储过程，位于xpstar.dll中，并由为扩展存储过程创建的特定引擎调用...

另请注意，这两个程序都是非文档的，因此您只能自担风险使用它们，Microsoft不会帮助您解决这些问题...

xp_readerrorlog is not a real stored procedure and sits inside the xpstar.dll, and called by a specific engine created for extended stored procedures...
Also notice that both procedures are NON-DOCUMENTED, so you can use them only at your own risk and Microsoft will not help you out with them...

它是在Sql server中： -

数据库 - >系统数据库 - > msdb - >可编程性 - >存储过程 - > System StoredProcedures - >在那里你会找到[sys]。[sp_readerrorlog]

It is in Sql server :-
Databases -> System Databases -> msdb -> Programmability -> Stored Procedures -> System StoredProcedures -> there you will find [sys].[sp_readerrorlog]

这篇关于哪些扩展存储过程存储在sql server中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！