I checked a bit that and I think it is not flexible and doesn't include many options. Even more, sometimes blocks the execution of the queries - makes delay.

Thank you, but this tool I think is not appropriate for this case. Do you have any other idea?

Any free tool?

Actually I need to generate specific number (1000, 2000 etc) of sql queries (insert, delete, update) in a specific schema.

I don't need to test the performance of the database.

Your suggestions are right, since I am working more in static way, selecting from string for few cases of SQL statements.

Using CDC or Change Tracking is better since it offers...

Thank you for your suggestions. I will look at it to see whether I can switch to that way.

I have seen CDC and Change Tracking, but my goal is...

In my case, since I need also to keep track of DatabaseName, TableName, UserName - that's why I am using audit logs and I can not use CDC since it...

I am working with SQL Audit Logs. I am auditing any update, delete, insert statement taken into specific table.

So, my goal is to extract column names that has been changed...

OK.

The situation is more complicated.

I am working with sql audit logs which I need to extract specific data (specific columns) and save them in text files.

Since from the...

that's the problem, since the tables are unequal and with different columns, BUT with same number of rows.

So, there is no option just take values of each row from the...

I want to select the values mentioned up from the string and here I have an example:

row_id=case when statement like '%UPDATE%'

then Left(SubString(statement, PatIndex('%[0-9]%', statement), 8000), PatIndex('%[^%[^0-9]%', SubString(statement, PatIndex('%[0-9]%', statement),...

Actually, I want to know whether it is possible to create a procedure from T-SQL on remote server, and than execute. Or, to create a SQL Job remotely (on the...

Thank you for the detailed explanation. It works!

I have another question.

How can I CREATE a PROCEDURE on the remote sql server?