Capturing SQL calls sent to a remote server from application First of all, I'm not well versed in SQL anything at all. Closest I've ever needed to get was storing and retrieving data from a local SQLite db.
In essence I think I have a simple problem but it's hard to orient yourself when everything is new.
My main tool at work is an ERP software, which is basically a front end to an SQL db.
Problem I have with it is that it's very clumsy and doesn't allow automation of even the most basic tasks.
What I want to do, is bypass the front-end completely and interact directly with the db to automate most of my tasks with python.
I can connect to the database just fine from python environment, but the schema is gigantic, there's no way I'll be able to find whatever it is I might be looking for.
So I need to capture the call front-end sends when I click a button (telling it to display specific set of data) to use that call as a guide.
Basically, how can I, an SQL noob, capture calls that a desktop application sends to a remote server?
Edit 1: My job is mostly analytical, so all of my automation will be for retrieval, analysis and visualization. I'm not very likely to mess anything up.
Edit 2: Tried running a Profiler and got the message:
&quot;In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission.&quot;
I'm not a sysadmin, don't have an alter trace permission and reeeally don't feel like asking for it :D
Depending on your SQL version, you could run a Query Trace or an Extended Event to capture the TSQL being run by your app.