Error while executing stored procedure

Question

Error while executing stored procedure

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Vijay

Those don't sound like SQL Server errors to me. Does your stored procedure use OPENROWSET or access a linked server? Are you able to post the code (CREATE PROCEDURE statements for EnableApplicationLogGrouping and DisableApplicationLogGrouping)?

John

Vijayrules4354 SSC Enthusiast Points: 181 More actions · Answer 2

Hi John,

I am not using any of OPENROWSET/Linked Servers. It's not a cross-server call. I am connecting to the same server from SSMS in my local then I am getting those errors if I do MSTSC and connect to the same server and execute the same procedure I am not getting the issue.

In my CREATE PROCEDURE statement, I am calling below procs for enabling and disabling the log.

EXEC dbo.EnableApplicationLogGrouping @ApplicationLogSourceName='Visualization', @Notes=@meta__ExecNote,@ProcObjectID=@@PROCID;

After a few line of code, I am calling

EXEC dbo.DisableApplicationLogGrouping @ProcObjectID=@@PROCID;

Thanks for your response.

Regards,

Vijay

frederico_fonseca SSCoach Points: 16279 More actions · Answer 3

it can be SQL Server - but without the code for both procs there's not much we can say