SQL SERVER 2016 (13.0.5026.0)
NOTE: The reference SQL code is not something I/We created but was setup by Prophix when they implemented the system for us. I am only responsible for trouble-shooting it when things fail, not for the T-SQL code it uses.
We have a B2B app named Prophix that drops an existing table in the DB and re-creates it via SELECT * INTO . The App uses a SQL Login that is a member of the DBO database role so it has the access needed to drop and re-create the table. Recently its been failing and the app is recording the error msg
Native SQL process was failed. Cannot drop the table 'vWAM_PROPHIX_GL_TOTALS', because it does not exist or you do not have permission.
Is this the kind of error that would be captured in the default trace? I've looked and have been unable to locate anything in the default trace for this but I don't know if this is something the default race would normally capture. I believe that when this fails its not b/c of the error the app lists but if this is something the default trace should record then I can use that prove that the error msg is wrong and that something else is preventing the code from running.
Kindest Regards,Just say No to Facebook!