sql 2005

Posted on 2008-11-13
Last Modified: 2012-08-14
Ho to grant access to  a developer to run sql profiler (sql2005)?  
what type of access he has to have on the SQL ?

Question by:MuraliPitani
    LVL 32

    Expert Comment

    by:Daniel Wilson

    But ... supposedly there's another way.  Have not tested it myself:

    Author Comment

    it shouldnt be sysadmin as far as i remember.. thats a case in sql 2000
    LVL 32

    Accepted Solution

    You're right ... in SQL 2005, there's a more granular way:
    GRANT ALTER TRACE TO John,289483,sid87_gci1127863,00.html
    btw, anything Adam Machanic writes is worth reading!

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now