Member Avatar for Kusno

Dear all,
I have a table that contains image data type and has more than 20,000 records.
I want to change its file group to the new file group.
I tried to change it using table designer, but everytime I wanted to save it, it occured an error with this message:

'TrxTransaction' table
- Unable to modify table.  
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.

Does anyone know how to change file group using alter table query?
I'm using SQL Server 2005.

  • 2 Contributors
  • 1 Reply
  • 134 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by pclfw
Member Avatar for pclfw

And have you tried looking in BOOKS ONLINE? If you don't have a copy then you can use the version on the Microsoft web site.

Search for ALTER TABLE

Edited by pclfw because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.