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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-26 : 09:14:43
|
| Sherry writes "I create a databases in SQL SERVER7.0 by using Enterprise Manager. I can't specify user defined filegroup by using this tool. But I use "Alter Database...ADD FILEGROUP..." and verify it by using "sp_helpfilegroup" in the database I created. The user defined filegroup shows on the results grid of Query Analyzer. Before I save a new table, I selected the properties option from the shortcut menu in this table. but the filegroup in the Table File Group field is only Primary. My questions are as below:A) I try to save this table into user defined filegroup. how can I do it?B) I thought Primay filegroup is supposed to store system table.Does it allow to store custom table too?C) Is "CREATE DATABASE" only option to set user defined filegroupduring the database creation? I can't find anyplace I can set user defined filegroup by using tools provided by SQL SERVER 7.0. Do I miss something ?Thanks a lot.Sherry" |
|
|
|
|
|
User defined filegroup question