SQL Server 2005
This is a discussion on SQL Server 2005 within the Database Support forums, part of the Web Development category; ALTER PARTITION SCHEME Change the allocation of a NEXT USED filegroup to a partition scheme. Syntax ALTER PARTITION SCHEME partition_scheme ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
03-22-2008, 01:08 AM
| |||
| |||
 Re: SQL Server 2005 ALTER PARTITION SCHEME Change the allocation of a NEXT USED filegroup to a partition scheme. Syntax ALTER PARTITION SCHEME partition_scheme NEXT USED [filegroup] [;] Key file_group A single filegroup to be designated as NEXT USED. Must already exist. The filegroup does not need to be empty, one file group may be used for multiple partitions. To remove the NEXT USED allocation, run the command without specifying any filegroup.
__________________ The MOSS Master of Solution Service     |
| Sponsored Links |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
LinkBacks (?)
LinkBack to this Thread: http://www.discussweb.com/database-support/4049-sql-server-2005-a.html | |||
| Posted By | For | Type | Date |
| rollback transactions: Blogs, Photos, Videos and more on Technorati | This thread | Refback | 10-12-2007 12:20 AM |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Server Assessment for Sql server 2005? | arjkhanna | Server Management | 3 | 10-30-2007 10:09 AM |
| SQL Server 2000 to 2005 | S.Vinothkumar | Database Support | 3 | 09-27-2007 03:22 AM |
| What is a Linked Server in sql server 2005? | Archer | Database Support | 2 | 08-14-2007 03:24 AM |
| What’s a “SAND BOX” in SQL Server 2005? | oxygen | Database Support | 1 | 07-26-2007 03:20 AM |
| What is the use of DBCC commands in sql server 2005? | Archer | Database Support | 1 | 07-25-2007 02:36 AM |
All times are GMT -7. The time now is 10:37 PM.
