June 10, 2002 at 1:57 pm
How could I specify a default filegroup for a particular user to use? (not all users)
-Kevin
June 10, 2002 at 2:18 pm
No way that I know of, other than build a wrapper proc/app that would set the filegroup when it was used. Normally you dont have many users creating db's, much less deciding where it goes!
Andy
June 10, 2002 at 5:04 pm
June 10, 2002 at 8:23 pm
There always exists a PRIMARY filegroup and you cannot change this. If you need to have a user use a specific filegroup set then have their tables created on another filegroup. Only tables (data and text/image seperatly configurable) and indexes can be moved to other filegroups.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply