Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-06-14 : 18:23:54
|
| Hi,We have a procedure where we create tables dynamically using select..into clause..Is it possible to specify filegroup when we create new table using SELECT..INTO clause or Is there any workaround..can we move table to different filegroup after creation using t-sql?Thanks--Harvinder |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-14 : 18:30:55
|
| You can move the table to a different filegroup by adding a clustered index on that filegroup - but would probably be etter off creating the table there in the first place rather than using select into.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SELECT..INT0 and filegroup clause