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 - 2001-05-20 : 22:56:26
|
Steve writes "I know its easy to change the default filegroup in SQL Server 2000 and also to change it to anything but PRIMARY in SQL Server 7 but how do I change it to PRIMARY in SQL Server 7 as it refuses to accept PRIMARY as a valid filegroupname
eg :-
ALTER DATABASE fred
MODIFY FILEGROUP Primary DEFAULT
but this works fine :-
ALTER DATABASE fred
MODIFY FILEGROUP readonlyfilegroup DEFAULT
Any help would be appreciated" |
|
|
|
|
|
Changing the default filegroup in SQL Server 7