Post reply

indexes option is not showing in sql server2005

  • April 22, 2009 at 1:06 am

    #129604

    Dear All,

    The indexes option is not showing in sql server2005 inside tables menu.but I want to make a cluster index on my database and I want to do it through GUI.

    Thanx

    Thanks

  • April 22, 2009 at 4:29 am

    #982049

    If you're creating a table, there should be a toolbar visible at the top of the screen that includes a button called "Manage Indexes and Keys." It shows a little stylized table with a key on top of it. That's where you go to work with indexes. If you can't see that tool bar when designing a table, right click on the toolbar area and select Table Designer or click on the View menu then the Toolbar popout and select Table Designer.

    If you're not designing a table, but instead want to create indexes on an existing table, you should be able to expand the table by clicking on the plus sign next to it. This will open a series of folders. One of them is Indexes. Right click on this and you should be able to create a new index.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 22, 2009 at 4:38 am

    #982057

    Thanks Fritchey...

    one thing I want to know what is the name of first paper of Mssql2005 for DBA

    Thanks

  • April 22, 2009 at 4:45 am

    #982059

    I'm sorry, "first paper"? Do you mean what do you read to get started? Personally I'd suggest you read Craig Mullin's "Database Administration" for a thorough overview of the job. Then I'd suggest Itzik Ben Gan's "T-SQL Fundamentals" for a good introduction to TSQL. After that things get fuzzy. You might want to post a new conversation asking for suggested reading to see what other people suggest. I'd post it in the General or the Newbie forum.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 22, 2009 at 5:47 am

    #982095

    MCTS 70-431

  • April 22, 2009 at 5:49 am

    #982097

    Pulikuttaaaaaaaaaaa 😀

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • April 22, 2009 at 11:18 pm

    #982661

    Thancs All

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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