SQL Server Performance Forum – Threads Archive

File Group Changes

How do i place table and index objects which resides in same Primary Group to seperate User File Groups? How can i achieve this task through T-SQL statements instead of Enterprise Manager?

I can’t find the way to separate filegroups using Query Analyzer. Even BOL said: use EM.
Of course if you create a script with table you want to move, recreate in new filegroup and copy data, is possible, but I don’t reccomend to do that. BTW:Why you don’t want to use EM?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Refer to BOL for ALTER DATABASE …. MODIFY FILEGROUP.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Touche(I don’t exactly how to spell) Satya. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks Luis
What does that mean? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

When you was looking for something a can see what obvius is, and other tell you: there is!!!, french people use Touche, like hat off. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>