• Richard Warr (7/22/2011)


    No, not everybody 🙂

    But, if you've been following the discussions on some recent questions you'll note that some people take the prospect of a point very seriously.

    I think the honourable approach is to try and answer the question straight away then, especially if you get it wrong. read the given reference and learn something.

    But that's just me - people are free to approach the scenario as best suits them. Invariably nobody gets hurt.

    My points are important. For me it's

    1. Take my best guess as to what the answer is

    2. Then try to find the answer and see if I'm correct. If I can't find it quickly enough, I stick with my gut instinct. In this case I was wrong. I suspected it was eitehr ALTER TRACE or must be sysadmin. Because of what policies are about, I went with SA required to test them as I figured that they could be created, but only SA's could actually deploy/test them. I was wrong, I still learned something.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]