Hi All,

Thanks for the response, and now one more doubt which might look funny. The db on which am assigned to work is used for report generation. The tables that I need to check do not have :

- Any official primary keys defined in the table.

- No reference i.e., foreign keys available.

- Almost all the columns have NonClustered index defined on Primary file group.

- One of the column (or group of columns i.e., composite) is defined as Unique, Clustered index on Primary.

In this scenario how do I go for defining of Partition on the table(s). My client is hell bent to have the partitioning concept implemented, reason he got his db's migrated from SQL 2K to 2K8 and wanted to implement the features.

Regards,

Sai Viswanath