If the student table: deleted drop table student;
This statement has been executed successfully, table student smoothly to delete,
And then execute it again to delete table operation: drop table student; Statement is not an error, the execution is successful,,
But the second is futile to delete to delete, how to filter out in SQL server profiler to track record second empty operation?

And whether it can filter out against a certain table insert or delete operation?

CodePudding user response:

Drop table student
The two specified error, can succeed the first time to delete the student table, the second will prompt: can't on the table 'student' to delete, because it does not exist, or you do not have the required permissions,

CodePudding user response:

reference 1/f, Yole response:

drop table student
The two specified error, can succeed the first time to delete the student table, the second will prompt: can't on the table 'student' to delete, because it does not exist, or you do not have the required permissions,

That how to filter out the profile writes 0 line?

CodePudding user response:

Profile is record of all the SQL operations, but the profile can separate the operation successful SQL statements to filter out, make successful with operation failed SQL statement from respectively? You could, how to filter

CodePudding user response:

Trace out data stored in tracking list, and then filter in tracking table,

Consider this:
https://blog.csdn.net/yole_grise/article/details/45745525