# Logstash JDBC Plugin

**URL:** https://discuss.elastic.co/t/logstash-jdbc-plugin/246910
**Category:** Logstash
**Created:** [August 31, 2020, 6:34am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin/246910 "2020-08-31T06:34:41Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Rahul12](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@Rahul12](https://discuss.elastic.co/u/Rahul12)
#### Post date: [August 31, 2020, 6:34am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin/246910/1 "2020-08-31T06:34:41Z")

</div>

Hi,  
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'))  
BEGIN  
DROP TABLE #errorlog  
END  
create table #errorlog(date\_time datetime,processinfo varchar(123),Comments varchar(max))  
insert into #errorlog exec sp\_readerrorlog  
select \* from #errorlog

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 28, 2020, 6:34am UTC](https://discuss.elastic.co/t/logstash-jdbc-plugin/246910/2 "2020-09-28T06:34:45Z")

</div>

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