Home Forums SQL Server 7,2000 Administration Lock tabels RE: Lock tabels

  • January 15, 2013 at 2:35 pm

    #1577543

    Krasavita (1/15/2013)

    Thank you,How you move the table into a separate filegroup?

    peek at the code i posted, which creates a new table in the filegroup.

    for an existing table, you can Use create index ... with drop_existing for the clustered index and specify the desired filegroup for the place that the index must be created on. , which effectively "moves" the table to the new filegroup.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!