October 29, 2010 at 1:23 pm
How do I capture CREATE VIEW with profiler? I thought selecting the OBJECTS events category would do it but that apparently only captures DROPs on Views even though it will capture DROP & CREATE on other objects like a table.
Is there some magic event for the CREATE side of VIEW DDL’s? This is so frustrating. I tried searching GOOGLE and I get 0 hits on the phrases below, amazing how hard it can be to to get the right formulation of words for a search phrase in Google.
WHY DOES PROFILER NOT CAPTURE CREATE VIEW
HOW TO CPATURE CREATE VIEW WITH PROFILER
PROFILER NOT CAPTURING CREATE VIEW
Kindest Regards,
Just say No to Facebook!October 29, 2010 at 1:49 pm
FYI - I fiugured it out. WHile the CREATE AND DROP TABLE DDL's can be caught with the same Event and COlumns as DROP VIEW, you aprently have to use a different combination to include CREATE VIEW in what you capture.
Am I the only one who has ever asked about this? It would seem to me that when you select Object:Create you shoudl capture any event that is the creation of an OIbject and that the same settings that capture CREATE or DROP for one shoudl work for the others.
Maybe its time to call it a weekend and go home?
Kindest Regards,
Just say No to Facebook!Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply