Professional Web Applications Themes

Rebuild index in SQL server ?? - Microsoft SQL / MS SQL Server

hi all, in access we have an "utility" to rebuild autonumeric index when a table is empty(Set the autonumeric to the first available number,erasing the previous index). How can I do it in SQL?...

  1. #1

    Default Rebuild index in SQL server ??

    hi all,
    in access we have an "utility" to rebuild autonumeric
    index when a table is empty(Set the autonumeric to the
    first available number,erasing the previous index). How
    can I do it in SQL?
    SAlva Guest

  2. #2

    Default Re: Rebuild index in SQL server ??

    Rebuilding an index and resetting an identity column are two different
    things.... you may rebuild indexes whenever you wish...

    To reset the identity column use dbcc check_ident. It is doented in books
    online....


    "SAlva" <sgomezNOSPAMMINGPLEASEhotetur.com> wrote in message
    news:039e01c33ef3$19c5e300$a001280aphx.gbl...
    > hi all,
    > in access we have an "utility" to rebuild autonumeric
    > index when a table is empty(Set the autonumeric to the
    > first available number,erasing the previous index). How
    > can I do it in SQL?

    Wayne Snyder Guest

  3. #3

    Default Rebuild index in SQL server ??

    check out DBCC CHECKIDENT in Books Online.

    Mark Baekdal
    dbghost.com
    >-----Original Message-----
    >hi all,
    >in access we have an "utility" to rebuild autonumeric
    >index when a table is empty(Set the autonumeric to the
    >first available number,erasing the previous index). How
    >can I do it in SQL?
    >.
    >
    mark baekdal Guest

  4. #4

    Default Re: Rebuild index in SQL server ??


    "mark baekdal" <nobodyherenowhere.com> wrote in message
    news:073901c33ef6$672f83f0$a301280aphx.gbl...
    > check out DBCC CHECKIDENT in Books Online.
    [SNIP]
    > >index when a table is empty(Set the autonumeric to the
    > >first available number,erasing the previous index). How
    > >can I do it in SQL?
    When the table is empty and you just want to reset the identity seed, you
    don't need any DBCC commands. Just issue a TRUNCATE TABLE on the empty
    table. Of course you don't want to do this on a table with data in it.


    Jeroen Schouten Guest

Similar Threads

  1. Newb query: index.htm & index.php & the server default
    By Lab309 in forum PHP Development
    Replies: 7
    Last Post: September 22nd, 02:08 PM
  2. Replies: 13
    Last Post: September 11th, 05:01 AM
  3. Index Server
    By cameron in forum ASP.NET General
    Replies: 2
    Last Post: July 17th, 05:58 PM
  4. How to insert data using index unusable/rebuild
    By aoshell2@yahoo.com in forum Oracle Server
    Replies: 0
    Last Post: July 10th, 08:06 PM
  5. Index Partition Rebuild is using Full Table Scan
    By Dave in forum Oracle Server
    Replies: 1
    Last Post: December 13th, 03:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139