Logstash JDBC Plugin

I am querying MS SQL database to fetch some monitoring parameter. I am using JDBC plugin and firing below query which giving me error. Resultset doesn't return any result.

I doubt that we can't use Create table query in JDBC plugin. Can you please confirm?

declare @errorlogcount int
IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N'tempdb..#errorlog'))
DROP TABLE #errorlog
create table #errorlog(date_time datetime,processinfo varchar(123),Comments varchar(max))
insert into #errorlog exec sp_readerrorlog
select * from #errorlog

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.