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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table partition in SQL 2000

Author  Topic 

vishu_av
Yak Posting Veteran

69 Posts

Posted - 2008-07-15 : 00:11:12
Hi all,
How can i achive a Horizontal partitioning for a Table in SQL 2000?
All i got in the site talked about partitioning in SQL 2005.
Please guide.

Thanks in advance

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-07-15 : 00:44:56
you do it with a partitioned view. see: http://msdn.microsoft.com/en-us/library/aa933141(SQL.80).aspx


elsasoft.org
Go to Top of Page

vishu_av
Yak Posting Veteran

69 Posts

Posted - 2008-07-15 : 02:21:25
Thanks. It was of great help
Go to Top of Page
   

- Advertisement -