Sql Server Procs created using wbinclude is not reflecting in DB

7 views
Skip to first unread message

Arunagiri M

unread,
Oct 26, 2021, 3:42:58 AM10/26/21
to SQL Workbench/J - DBMS independent SQL tool
Hi Team,

I have created a procedure in a remote db using workbench command line, when I run WbListProcs , I can see the proc but when I checked in the database  it is not reflecting. Please help me to resolve this.

Thanks,
Arun

Thomas Kellerer

unread,
Oct 27, 2021, 2:35:30 AM10/27/21
to sql-wo...@googlegroups.com
Sounds as if you are not committing the CREATE PROCEDURE statement.

Either add the COMMIT or make sure you enable Autocommit in the connection profile.

Arunagiri M

unread,
Oct 27, 2021, 5:15:01 AM10/27/21
to sql-wo...@googlegroups.com
Thanks Thomas.

Regards,
Arun

--
You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/71a35ccf-1c14-32b2-25d1-7eb8ba02c189%40sql-workbench.net.
Reply all
Reply to author
Forward
0 new messages