Post reply

Perform index analysis

  • November 7, 2001 at 7:51 am

    #78121

    Dear all,

    At a clients site, I'm not allowed to select "Query", "Perform index analysis" in SQL Query Analyser.

    What rights do I need in order to be able to do that?

    TIA

    Henrik Staun Poulsen

    Stovi Software

    Denmark

  • November 7, 2001 at 10:09 am

    #419777

    I don't see this option. Is this in SQL 7 or 2000?

    Steve Jones

    steve@dkranch.net

  • November 7, 2001 at 10:28 am

    #419781

    This is a SQL 7.0 menu option, and I believe it's only sysadmin fixed database role who has the right, although I'm not sure what actual command is being executed.

    Paul Ibison

    email: Paul.Ibison@btinternet.com


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • November 7, 2001 at 11:02 am

    #419783

    Don't have any v7 servers here. Try running profiler with the sa logon and see what happens.

    Steve Jones

    steve@dkranch.net

  • November 8, 2001 at 3:43 am

    #419815

    Steve,

    <Try running profiler with the sa logon and see what happens.>

    Ok, I'll try to do that the next time I'm on-site. I'll get back to you on Tuesday, if that's ok with you.

    Best regards

    Henrik

  • November 8, 2001 at 3:43 am

    #419814

    Steve,

    <Try running profiler with the sa logon and see what happens.>

    Ok, I'll try to do that the next time I'm on-site. I'll get back to you on Tuesday, if that's ok with you.

    Best regards

    Henrik

  • November 8, 2001 at 8:43 am

    #419820

    Anytime is fine. We check these forums most eveery day.

    Steve Jones

    steve@dkranch.net

  • November 13, 2001 at 9:39 am

    #420055

    Steve,

    When I go into Profiler, with my password, I get the following:

    EXECUTE permission denied on object 'xp_trace_addnewqueue', database 'master', owner 'dbo'

    I do not have access to the SA account. I'm just a systems developer that needs to install a few tables out on a clients site. And it is here the real data is, so it would be a very nice opportunity to perform an index analysis on selected SQL.

    Best regards

    Henrik

  • November 13, 2001 at 10:23 am

    #420061

    It is a security problem. I believe the XP_trace procedures are limited to sysadmin role members. If you can get added, this should work.

    If not, then you will have to analyze the indexes on a copy of the db on another server or get an admin to do it for you.

    Steve Jones

    steve@dkranch.net

  • November 15, 2001 at 2:57 am

    #420111

    Steve,

    Thank you for your help. I have managed to become a dbo of the database. Great.

    Now I must not make any mistakes, and delete stuff that belongs to somebody else.

    Best regards

    Henrik

  • November 15, 2001 at 2:57 am

    #420110

    Steve,

    Thank you for your help. I have managed to become a dbo of the database. Great.

    Now I must not make any mistakes, and delete stuff that belongs to somebody else.

    Best regards

    Henrik

  • November 15, 2001 at 3:04 am

    #420112

    Steve,

    Thank you for your help. I have managed to become a dbo of the database. Great.

    Now I must not make any mistakes, and delete stuff that belongs to somebody else.

    Best regards

    Henrik

  • November 15, 2001 at 3:16 am

    #420114

    Steve,

    Thank you for your help. I have managed to become a dbo of the database. Great.

    Now I must not make any mistakes, and delete stuff that belongs to somebody else.

    Best regards

    Henrik

  • November 15, 2001 at 3:16 am

    #420113

    Steve,

    Thank you for your help. I have managed to become a dbo of the database. Great.

    Now I must not make any mistakes, and delete stuff that belongs to somebody else.

    Best regards

    Henrik

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply